Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
64 | |
60 | |
51 | |
36 | |
36 |
User | Count |
---|---|
81 | |
72 | |
58 | |
45 | |
44 |