Custom Slicer: All values and all except one

Hi crln-blue ,

Based on your description, you can do some steps as follows.

1. create a table that contains only "All materials except material B" and "All materials". (I used "Enter Data" option)

2. create a measure and drag it to the filter of the table visual.(is equal to 1)

Measure = 

var x1=SELECTEDVALUE('slicer'[S])

var x2=IF(MAX('Query1'[material])<>BLANK(),"All materials")

var x3=IF(MAX('Query1'[material])<>"B","All materials except material B")

return

IF(x1="All materials",1,IF(x1=x3,1,0))