Forum Discussion

richard_wylde's avatar
richard_wylde
Icon for Helper IV rankHelper 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
richard_wylde's avatar
richard_wylde
Icon for Helper IV rankHelper IV
6 years ago

Hi dax  Greg_Deckler 

 

thanks for your replies, sorry I wasn't able to explain it clearly - are you able to download this example? 

 

So when I view the following measure in a table it correctly falls into the highlighted green clause, which returns 'Marriage' :-
 
also working = IF ( isfiltered ( choose_dimension[choice]), VALUES ( choose_dimension[choice] ), "Not Working" )
 
However when I reference the result of this measure from within the following measure I can't understand why it is not falling into the green clause. Instead it is returning the red clause, which is the result of the previous measure, however the previous measure is now "Not Working"
 
= if( 'Query1'[also working] = "Marriage", 'Query1'[Mar_desc], 'Query1'[also working] )
 
I hope this makes sense, let me know if there's anything else you need from me,
 
Thank you.
 
dax's avatar
dax
Icon for Community Support rankCommunity 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
    Icon for Helper IV rankHelper 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