Use Measure as Slicer

[jmarcrum]

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

[v-lid-msft · Accepted solution]

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]

what is the category measure calculation?

[jmarcrum]

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)")))

[Greg_Deckler]

So many times you can do something like:

VAR __Selections = 'Slicer'[Categories]

Then you can do a filter like:

FILTER('Table',[Column] IN __Selections)

[Anonymous]

@Greg_Deckler could you give a more specific explanation? tnahk you!