Forum Discussion
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 and am able to filter the visual one at a time using the following formula on my visual level filter:
Category Selection = IF(SELECTEDVALUE(Category[Value])=[Category Measure],1,0)
Is there a way to filter on multiple values?
See screenshots below with my steps.
Thank you in advance!
Table visual
table visual
measure slicer
measure slicer
filter on single value
filter on a single value
filter on multiple values
filter on multiple values
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,
5 Replies
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,So many times you can do something like:
VAR __Selections = 'Slicer'[Categories]
Then you can do a filter like:
FILTER('Table',[Column] IN __Selections)
@Greg_Deckler could you give a more specific explanation? tnahk you!
what is the category measure calculation?
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)")))
