Remove row in 1st table based on slicer in Table 2

[Anonymous]

Hi

I have 2 tables : Customer table and Product table. These 2 are in 1 to many relationship. Each customer might have different product or even same product. What I'm trying to achieve is that whenever Product slicer is chosen (in this example - to exclude Product 1), customer that has only Product 1 to be excluded. If a customer has Product 1 and 2, he should still be in the list.

I have applied filter to exclude product 1, but it still show customer A that has only Product 1.

What would be the best solution on this? Any help greatly appreciated. Thank you.

Table 1

Customer	Address	Phone
A	X	123
B	Y	345
C	Z	456

Table 2

Customer	Product
A	1
B	1
B	1
B	2
C	3

Slicer : Table 2 = to exclude Product 1

Desire Outcome in table 1

Customer	Address	Phone
B	Y	345
C	Z	456

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

You need to create an unrelated product table as a slicer.

Then create a measure and apply it to the visual level filter.

Measure = IF(ISFILTERED('Table'[Product])&&MAX(Table2[Product]) in VALUES('Table'[Product]),1,0)

Sample .pbix

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.