Sum Value of multiple Categories

[BigKev]

Hi All,

Does anyone know what is the dax measure to sum the value of two category?

This is my data set:

Category	Value
A	1
B	2
C	3
D	4
E	5

What I want to is to create a measure to sum Category A & B, which will return me with a result of 5.
I have tried "Total A&B = calculate(sum(Value),Category="A" && Category="B") ". However it return me with blank.

Please Help. 

Cheers,

Kev

[Jihwan_Kim]

Hi, @BigKev 

Please try something like below.

Total A&B = calculate(sum('Table'[Value]), 'Table'[Category] ="A" || 'Table'[Category]="B")

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[jthomson · Accepted solution]

Use a pipe instead of &. Your formula is saying it needs to be category A and B at the same time, rather than one or the other