Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

SUM With Multiple Filters

Hi,

I have Table with Category, Month and Value:

CategoryMonthValue
WJan1
XJan1
YJan0
ZJan3

 

I want a measure that tells me what the sum of Value is for just the W and X, so for January the total would be 2. I thought I could use:

CALCULATE(SUM('Table'[Value]), 'Table'[Category] = "W", 'Table'[Category] = "X")

 

But this comes back blank. What am I missing?

 

Thanks,

Need Help
  • FrankAT's avatar
    FrankAT
    5 years ago

    Hello @SKH19

    measure should be:

    10-09-_2020_22-24-26.png

    Sum of W or X = 
CALCULATE(
    [Sum of Value],
    'Table'[Category] = "W" || 'Table'[Category] = "X"
)

    With kind greetings from the city where the legend of the 'Pied Piper de Hamelin' is at home
    FrankAT (Proud to be a Datanaut)

1 Reply

  • FrankAT's avatar
    FrankAT
    Community Champion
    5 years ago

    Hello @SKH19

    measure should be:

    10-09-_2020_22-24-26.png

    Sum of W or X = 
CALCULATE(
    [Sum of Value],
    'Table'[Category] = "W" || 'Table'[Category] = "X"
)

    With kind greetings from the city where the legend of the 'Pied Piper de Hamelin' is at home
    FrankAT (Proud to be a Datanaut)