Forum Discussion

richard_wylde's avatar
richard_wylde
Helper IV
6 years ago

Selected Value not displaing

Hello,   In this Example  I can successfully show the name chosen in the filter choice using    chosen_column= IF ( isfiltered ( choose_dimension[choice]), VALUES (choose_dimension[choice]), "Not...
Need Help
dax's avatar
dax
Community Support
6 years ago

Hi richard_wylde , 

As I mentioned above, calculated column value can't be affect by slicer(even you refer to measure), so the isfilter() in measure(also working) can't work in calculated column(Grrr - why is this not working though?). I suggest you use measure to achieve this goal.

By the way, I want to know when 'Query1'[also working] = "Marriage", what result did you want to get in table?

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

richard_wylde's avatar
richard_wylde
Helper IV
6 years ago

Hi dax 

 

Thanks for explaining, it's most annoying that a calculated measure can read a slicer value but a calculated column cannot. I need to be able to identify a column chosen by the user, in order to pass the column into other mesures. (I've updated the example   ) - do you know if there is another way to do this ?

 

Thank you