slicers must match all data

[Cblankenship]

I am attempting to do a multiple select on my slicers. It is returning it in an OR statement. I would like for it to return in an AND statement. 

For example:

If Property X is Gulf Front and Full Ocean View and Property A is Gulf Front and Partial Ocean view. In my slicer, i want to select Gulf Front, Full Ocean View. Currently it is returning properties A and X. because they both have Gulf Front Selected. I would like for it to only return property X. Any ideas?

[v-shex-msft · Accepted solution]

HI @Cblankenship,

Slicer can't direct achieve 'and' operation, I'd like to suggest you write a measure to check tag, then use this measure to filter table.

Below is the sample.

Sample tables:

Test = DATATABLE("Type",STRING,{{"A"},{"B"},{"C"},{"A,B"},{"A,C"},{"B,C"},{"A,B,C"}}) 

Selector Table = DATATABLE("Item",STRING,{{"A"},{"B"},{"C"}})

Measrue:

Select Tag = 
var currnet_Item=LASTNONBLANK(Test[Type],[Type])
return
IF(currnet_Item=CONCATENATEX(ALLSELECTED('Selector Table'[Item]),[Item],","),1,0)

Use 'Selector Table' as the source of slicer, create table visual and drag measure as visual level filter.

Regards,

Xiaoxin Sheng