Forum Discussion

ryanjparks's avatar
ryanjparks
Helper I
3 years ago
Solved

SELECTEDVALUE - Sum With Multiple Selections

Hello Everyone,

 

I have a question as to how I can apply a multiple criteria selection in a Slicer and sum up the total? Unfortunately this is not as simple as it sounds. I need to list the Customer and their Total Sales next to each other in a Table, as well as the Selected Sales next to Total Sales.

 

Even if Selected Sales is $0, I need to display that row because the Customer has other sales. This is what I have for the DAX measure for Selected Sales:

 

 

Selected Product Sales = 
    VAR a = SELECTEDVALUE(MySales[Product],0)
    VAR b = 
        CALCULATE(
        SUM(MySales[Amount]),
        FILTER(MySales, MySales[Product] = a)
    )
    RETURN b+0

 

 

The slicer is set to select the Product from the Product Table, which is not related to the MySales table. This all works perfectly when selecting a single Product. But when I select multiple products, the resulting Sum of Selected Sales goes to $0.

 

How can I change this to sum up the total sales of all Products selected in the slicer? SELECTEDVALUE doesn't seem to be the appropriate option...

 

Thanks for any help!

  • johnt75's avatar
    johnt75
    3 years ago

    To get 1 or more selected values you can use VALUES, e.g.

    Selected Product Sales =
CALCULATE (
    SUM ( MySales[Amount] ),
    TREATAS ( VALUES ( 'Product'[Product] ), MySales[Product] )
) + 0

2 Replies

  • johnt75's avatar
    johnt75
    Super User
    3 years ago

    To get 1 or more selected values you can use VALUES, e.g.

    Selected Product Sales =
CALCULATE (
    SUM ( MySales[Amount] ),
    TREATAS ( VALUES ( 'Product'[Product] ), MySales[Product] )
) + 0