Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!)
Solved! Go to Solution.
Hi,
PBI file attached.
Hope this helps.
Hi,
Share data in a format that can be pasted in an MS Excel file and show the expected result very clearly.
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 |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |