Forum Discussion

ryanjparks's avatar
ryanjparks
Icon for Helper I rankHelper 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 Custom...
  • 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
ryanjparks's avatar
ryanjparks
Icon for Helper I rankHelper I
3 years ago

Wow, that was fast and worked perfectly! Thank you so much!!!