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
dax's avatar
dax
Icon for Community Support rankCommunity Support
6 years ago

Hi richard_wylde , 

As I know, slicer couldn't affect calculated column, it will work on measure. So you need to use measure to  achieve this goal.

Measure = if( convert('Query1'[also working],STRING) = "Marriage", min('Query1'[Mar_desc]), convert('Query1'[also working],STRING)  )

By the way, I am not clear your expected output, so if possible could you please inform me more detailed information(such as your expected output and your sample data )? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
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  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