Values in What If Parameter not updating in Calculated Columns

[vaibhav201092]

Hello,

Ratio	Flag
0.1	Less Than Median
4.2	Greater Than Median
3.1	Less Than Median

I have the calculated column "Ratio" in my data, I want to take a "Median" value which will be entered by the user as a parameter, for example 3.5, and then create the "Flag" calculated column accordingly. I have also read somewhere that calculated columns do not get updated dynamically and hence do not use the latest parameter value. Even when I refreshed the data, the calculated columns were not picking up the manually selected parameter value and were using the default parameter value. What could be the workaround for this?

Thanks

[amitchandak]

@vaibhav201092 , Calculated column can not use slicer value

[vaibhav201092]

Is there a workaround to this using measures?