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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
AndySmith
Helper II
Helper II

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.