Forum Discussion

Myurathan's avatar
Myurathan
Frequent Visitor
8 years ago
Solved

Different between calculated column and measure (Using SUM function)

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 :)

 

 

Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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