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,

     

vanessafvg's avatar
vanessafvg
Community Champion
6 years ago

what is the category measure calculation?

  • jmarcrum's avatar
    jmarcrum
    Helper II
    6 years ago

    Category Measure =
    IF(ISBLANK(CBM_ROUTES_2[X_DELTA]),"not enough data",
    IF([X_MAX_BW_X_FOR]<[X_AVG_DAYS_BTW_MEASUREMENTS],"Not performed often enough",
    IF([X_MIN_BW_X_FOR]>[X_AVG_DAYS_BTW_MEASUREMENTS],"Performed too often","OK (within bandwidth)")))