SUM With Multiple Filters

[SeanHenderson]

Hi,

I have Table with Category, Month and Value:

Category	Month	Value
W	Jan	1
X	Jan	1
Y	Jan	0
Z	Jan	3

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,

[FrankAT · Accepted solution]

Hello @SKH19

measure should be:

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)