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