Show values that exist in all selections

[Bunim]

Dear all,

How do i get values that exists in all selections?

For example i want to get all customers that exist in Club A and (not or !) exist in Club B etc..

Thanks,

Bunim.

[Taoufiq_Zarra]

@Bunim  can you share a sample data and the expected output ?

[Bunim]

The table look like this -

Club	Customer
A	Moty
A	Bunim
B	Bunim
B	Rivka
B	Miriam
C	Moshe
C	Sara

I have a filter on Club that i can select A or B or C.

I have a KPI that count  Customers. so without selection i will get the count for all Customers and if i select A the count will be 2 (Moty and Bunim).

I want that if i select A and B i will get 1 because they have only one Customer the same (Bunim).

Thanks.