cancel
Showing results for
Did you mean:
Helper II

## Sum Value of multiple Categories

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.

Cheers,

Kev

1 ACCEPTED SOLUTION
Solution Sage

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

2 REPLIES 2
Community Champion

Hi, @BigKev

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.

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.

Best regards, JiHwan Kim

Solution Sage

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

Announcements