Forum Discussion
Slicer return all values except the selected values
Greeting! Is there a way to create a slicer to return all values except the selected values. For example: My table --------------- A B C If user select 'A' in the slicer, then it will...
Anonymous , for that your slicer should come from an independent table that has these values.
Add this measure with this column having A,B, C (assume Type)
Measure =
var _1 = except(All(Table[Type]), allselected(Type[Type]))
return
calculate(countrows(Table), filter(Table, Table[Type] in _1))
amitchandak
Super User
Super UserAnonymous , for that your slicer should come from an independent table that has these values.
Add this measure with this column having A,B, C (assume Type)
Measure =
var _1 = except(All(Table[Type]), allselected(Type[Type]))
return
calculate(countrows(Table), filter(Table, Table[Type] in _1))
amitchandak that worked!! Thanks!