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 return 'B' and 'C'.
Your assistance is appreciated.
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))
3 Replies
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 that worked!! Thanks!
How to achieve this functionality without creating independent table.
I'm using direct query mode.
