Slicer return all values except the selected values

[Anonymous]

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.

[amitchandak · Accepted solution]

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

[Sidror]

How to achieve this functionality without creating independent table.

I'm using direct query mode.

[Anonymous]

@amitchandak that worked!! Thanks!