Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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)