Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How to change values of calculated column dynamically, based on filters applied

I have a simple report with a simple table; The standard dev is a measure. I have created a calc column that basically checks each of the durations, against the Standard Dev value. (if it's l...
Need Help
Show and Tell
v-eachen-msft's avatar
v-eachen-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous ,

 

You may use measure if you need a series of dynamic values after applying filters. 

Measure =
VAR SD1 =
    CALCULATE ( STDEV.P ( 'Table1'[Duration (s)] ), ALLSELECTED ( 'Table1' ) )
VAR d =
    SELECTEDVALUE ( 'Table1'[Duration (s)] )
RETURN
    SWITCH ( TRUE (), d < SD1, "less", d > SD1, "more" )

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    thanks for this answer, although in a table view this does appear to be giving correct results, however when plotting the values on a line or bar chart, it refuses to take this measure. So, for example, I wanted to plot the number of more's/lesses against the country. Any ideas?