Customers who buy X but not Y

[AndySmith]

Hi

I have a large fact table across multiple brands and products. I want to filter a list of customers to a brand (from either Slicer/drop down) and then filter the list further by those customers who have purchased X (selectable from dropdown/slicer) but have NOT purchased Y (this target product being selectable from drop down) 

Is this possible? Have tried 2 product slicers however the first slicer one of course then filters the second one (which is not what I need!)

[Ashish_Mathur]

Hi,

Share data in a format that can be pasted in an MS Excel file and show the expected result very clearly.

[AndySmith]

Hi.

See below. Hope this helps!

I would like the 2 filters to result in the output table.

The output shows all the sales of customers who purchased Pinot Noir but DID NOT purchase Shiraz

INPUT 

CustomerBrandProductSales

Customer AAA	Brand A	Shiraz	50
Customer AAA	Brand A	Pinot Noir	20
Customer AAA	Brand A	Rielsing	30
Customer BBB	Brand A	Pinot Noir	50
Customer CCC	Brand A	Shiraz	100
Customer CCC	Brand A	Pinot Noir	80
Customer CCC	Brand A	Rielsing	50
Customer DDD	Brand A	Riesling	20
Customer DDD	Brand A	Pinot Noir	60
Customer EEE	Brand A	Shiraz	60
Customer EEE	Brand A	Pinot Noir	25
Customer EEE	Brand A	Rielsing	80
Customer FFF	Brand A	Shiraz	95
Customer FFF	Brand A	Pinot Noir	60
Customer FFF	Brand A	Rielsing	65
Customer GGG	Brand A	Shiraz	85

 OUTPUT

CustomerBrandProductSales

Customer BBB	Brand A	Pinot Noir	50
Customer DDD	Brand A	Riesling	20
Customer DDD	Brand A	Pinot Noir	60

[Ashish_Mathur · Accepted solution]

Hi,

PBI file attached.

Hope this helps.