Forum Discussion
Anonymous
7 years agoNot applicable
Compare/benchmark values from one table, using two separate slicers
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)
Anonymous,
You may refer to the post below.
2 Replies
- v-chuncz-msftCommunity Support
Anonymous,
You may refer to the post below.
- AnonymousNot applicable
Worked like a charm, thanks a lot!