Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi!
I have an issue were I want to make a "grouping/benchmark" based on selected customers/values in two separate slicers, where the source is the same table.
I have tried with solutions from here, but this only works for single selection (like illustrated below). The main goal would be to select several values from each slicers, and then let the measure sum up based on the selections done. But still only show two lines (one for each selection in the slicers).
Thanks!
Sum product for slicer1 = CALCULATE ( SUM ( Product_sales[Sales] ), FILTER ( Product_sales, Product_sales[Product] = LASTNONBLANK ( Slicer1[Product], 1 ) ) ) Sum product for slicer2 = CALCULATE ( SUM ( Product_sales[Sales] ), FILTER ( Product_sales, Product_sales[Product] = LASTNONBLANK ( Slicer2[Product], 1 ) ) ) Isblank for slicer1 = IF([Sum product for slicer1]=BLANK(),0,1) Isblank for slicer2 = IF([Sum product for slicer2]=BLANK(),0,1)
Solved! Go to Solution.
@Anonymous,
You may refer to the post below.
@Anonymous,
You may refer to the post below.
Worked like a charm, thanks a lot!
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
66 | |
34 | |
26 | |
22 |
User | Count |
---|---|
97 | |
96 | |
58 | |
45 | |
42 |