Reverse select of one slicer

[kongyuancn]

Hi There,

I have a small table:

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUUoE4mQgTlWK1YlWMoKKpABxGljEGMhKgqqBiJhARVLgukxR1cQCAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [id = _t, type1 = _t, type2 = _t, type3 = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"id", Int64.Type}, {"type1", type text}, {"type2", type text}, {"type3", type text}})
in
#"Changed Type"

I created three slicers on the page

It looks good.

Now I want to do is to reverse select the slicer 1 (type1), and keep other slicers working as above. How can I write the dax?

[kongyuancn]

@Greg_Deckler Thank you for your info.

[Greg_Deckler · Accepted solution]

@kongyuancn Like this? Inverse Selector - Microsoft Power BI Community