Different between calculated column and measure (Using SUM function)

[Myurathan]

Hi!

I couldn't get my head around with evaluation context of DAX. What is the difference between following calculated column and measure, in terms of pivottable?

[Sum of unit price CC]=sum('Sales'[Unit Price])

[Sum of unit price M]:=SUM('Sales'[Unit Price])

When I use these two in the pivot table with filters, they give different answers. Can anyone explain how do they get computed in PivotTable filtered environment?

Thanks a lot for your help 🙂

[v-shex-msft · Accepted solution]

Hi @Myurathan,

I would like to suggest you take a look at below blog which told about difference between calculated column and measure:

Calculated Columns and Measures in DAX

Notice:

1. Calculation column/table not support dynamic changed based on filter or slicer. (So sum(table[column]) will return fixed value)
2. Measure can be affected by filter/slicer, so you can use it to get dynamic summary result.

Regards,

Xiaoxin Sheng