Here’s a comparison in table format:

Feature New Measure New Column
Purpose Aggregates or summarizes data dynamically Row-by-row calculations for each row
Calculation Context Depends on report filter and context Static; calculated once during data refresh
Performance More efficient; calculated only when needed Less efficient; stored in the data model
Use Case Dynamic results (e.g., totals, averages) Row-level calculations (e.g., classifications)
Example Total Sales = SUM(Sales[Amount]) Age Group = IF(Employees[Age] > 40, "Older", "Younger")

Now we want Total Profit

Right click Orders > New Measure >

Copy of Copy of class Car def init(self, brand, model) self.brand = brand self.model = model (18).png

Now go to the Table view

Right click Orders > New Column

Copy of Copy of class Car def init(self, brand, model) self.brand = brand self.model = model (19).png

Type the same formula

Copy of Copy of class Car def init(self, brand, model) self.brand = brand self.model = model (20).png

New column is added

But here the problem is, the value is same for all the rows

Se we have to modify the formula

Just remove the SUM