Remove Customers who have bought a products from different category

[avulasandeep]

Hi 

here is the question 

remove  the customers who had  brought category  1 and 2

category 1: product 1 , product  2 as well as product 3

category 2 : product 1

category 3 : Product 2 and Product 3  but not product 1

here i need the customers who had brought only product 2 and 3 from category 

Thanks 

Sandeep

[v-huizhn-msft]

Hi @avulasandeep,

What your resource table look like? We can not post the detail DAX code without your sample table. Please share your sample table and list the expected result. So that we can help you directly. If your data is confidential, you can create similar structure fake sample table.

Best Regards,
Angelia