Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
AndySmith
Helper III
Helper III

Customers who buy X but not Y

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!)

1 ACCEPTED SOLUTION

Hi,

PBI file attached.

Hope this helps.

Ashish_Mathur_0-1713066271012.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

3 REPLIES 3
Ashish_Mathur
Super User
Super User

Hi,

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi.

 

See below. Hope this helps!

 

AndySmith_0-1712979736103.png

 

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 AAABrand AShiraz50
Customer AAABrand APinot Noir20
Customer AAABrand ARielsing30
Customer BBBBrand APinot Noir50
Customer CCCBrand AShiraz100
Customer CCCBrand APinot Noir80
Customer CCCBrand ARielsing50
Customer DDDBrand ARiesling20
Customer DDDBrand APinot Noir60
Customer EEEBrand AShiraz60
Customer EEEBrand APinot Noir25
Customer EEEBrand ARielsing80
Customer FFFBrand AShiraz95
Customer FFFBrand APinot Noir60
Customer FFFBrand ARielsing65
Customer GGGBrand AShiraz85

 

 OUTPUT

 

CustomerBrandProductSales

Customer BBBBrand APinot Noir50
Customer DDDBrand ARiesling20
Customer DDDBrand APinot Noir60

 

 

 

 

Hi,

PBI file attached.

Hope this helps.

Ashish_Mathur_0-1713066271012.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.