Test the value of a slicer in DAX

[Anonymous]

I have a slicer with two items. I need to blank out several fields in the report if the second item in the slicer list is selected. How can I check which item in the list of the slicer is selected in DAX statement?

Thanks, Mark

[AlexisOlson · Accepted solution]

If your slicer is on Table1[ColumnA], then VALUES(Table1[ColumnA]) should give you a list of distinct values that you have selected with your slicer. You can test if an item is in that list using IN. For example, if it's the text string "Second Item", then you'd write

"Second Item" IN VALUES(Table1[ColumnA])

which will return True or False.

[v-yuezhe-msft · Accepted solution]

@Anonymous,

Create a measure in your table using DAX below.

Measure= if(SelectedValue(Table[slicerfield])="seconditem name",<value_if_true>, <value_if_false>)  

If you still have questions, please share sampled data of your table and post expected result here.

Regards,
Lydia

[AlexisOlson · Accepted solution]

If your slicer is on Table1[ColumnA], then VALUES(Table1[ColumnA]) should give you a list of distinct values that you have selected with your slicer. You can test if an item is in that list using IN. For example, if it's the text string "Second Item", then you'd write

"Second Item" IN VALUES(Table1[ColumnA])

which will return True or False.