Can I create filter with overlapping values?

[rakunn]

Hello data heroes!

I would like to ask if there is a possibility to create filter with overlapping values? Let's say, I have a table with cars and their statuses:

CarID	Status
1	Rent
2	Rent
3	Broken & Rent
4	Broken & Vacant
5	Vacant
6	Vacant

Do you think, that it is possible to create single filter with three buttons / selectors, working as below?

* Clicking on Rent will return cars with id 1, 2 and 3.

* Clicking on Broken will return cars with id 3, 4.

* Clicking on Vacant will return cars with id 5, 6.

Thank you! All the best,

rakunn

[v-yulgu-msft · Accepted solution]

Hi @rakunn,

You should have a single table to list all available slicer selections.

Create a measure. And add it to visual level filter, set its value to 1.

Check_Measure = 
IF ( ISERROR(FIND(SELECTEDVALUE ( Table7[Column1] ) ,LASTNONBLANK(Table6[Status],1 ))), 0, 1 )

Best regards,

Yuliana Gu