Forum Discussion
Solved
Summing two rows within table
I have a table as below.
I want to create a measure who calculates the sum of category A and C for "Actuals". Returning 18.
Thank you
| Category | Actuals | Last Year |
| A | 10 | 15 |
| B | 5 | 14 |
| C | 8 | 6 |
| D | 9 | 18 |
Ptolemaida , Create a new measure
DAX
Sum_A_and_C =
CALCULATE(
SUM('YourTable'[Actuals]),
'YourTable'[Category] IN {"A", "C"}
)
1 Reply
Ptolemaida , Create a new measure
DAX
Sum_A_and_C =
CALCULATE(
SUM('YourTable'[Actuals]),
'YourTable'[Category] IN {"A", "C"}
)