Forum Discussion
Measure Using SWITCH Not Applying Filters to Underlying Measures
I am trying to minimize the number of measures I am using in a dashboard. I ended up creating several that are nearly identical so I thought I could use some IF statements to reduce the amount of mea...
You are right, Power bi not support create a dynamic calculated column based on slicer/filter, the calculated column has the "row context" of the current row. It is calculated once when the data set is loaded, and the stored value will not change according to the user's selection, that is, it is not affected by, for example, the slicer.
Measures are dynamic, they are calculated when necessary, so they will respond to the slicer in the report.
This is the difference between calculated column and measure:
https://radacad.com/measure-vs-calculated-column-the-mysterious-question-not
Best Regards,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.