How to exclude table rows from a Slicer

[kayw]

I have 3 tables, Sales Records, Products, Customer.

Sales Records

Customer	Product	PurchaseDate
A	P1	20170101
A	p2	20170501
B	P1	20171022
C	P3	20170507

Is it possible to create a Product Slicer to give me all the customer who have never purchase the selected product?

For example, 

in my slicer, i have the ability to choose P1 to P4. When P1 is selected, the result should display Customer C..

Product	Name	Unit Price
P1	n1	1
P2	n2	2
P3	n3	3
P4	n4	4

[v-chuncz-msft · Accepted solution]

@kayw,

You may drag [Customer] from Customer Table and the following measure to a Table visual.

flag =
VAR c =
    MAX ( Customer[Customer] )
RETURN
    IF (
        COUNTROWS (
            FILTER (
                'Sales Records',
                'Sales Records'[Customer] = c
                    && 'Sales Records'[Product] IN VALUES ( Products[Product] )
            )
        )
            = 0,
        1
    )