Forum Discussion

jmarcrum's avatar
jmarcrum
Helper II
6 years ago
Solved

Use Measure as Slicer

Hi everyone -   I am trying to use the text values from a measure in a slicer on my table visual.  I created a separate table called "Category" that holds the possible text values from the measure ...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi jmarcrum ,

     

    We can change the measure as following to meet your requirement:

     

    Category Selection =
IF ( [Category Measure] IN DISTINCT ( Category[Value] ), 1, 0 )

     


    Best regards,

     

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi jmarcrum ,

 

We can change the measure as following to meet your requirement:

 

Category Selection =
IF ( [Category Measure] IN DISTINCT ( Category[Value] ), 1, 0 )

 


Best regards,