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('S...
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