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 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!
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 |
---|---|
113 | |
97 | |
79 | |
74 | |
56 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |