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 ...
Ptolemaida , Create a new measure
DAX
Sum_A_and_C =
CALCULATE(
SUM('YourTable'[Actuals]),
'YourTable'[Category] IN {"A", "C"}
)
Ptolemaida , Create a new measure
DAX
Sum_A_and_C =
CALCULATE(
SUM('YourTable'[Actuals]),
'YourTable'[Category] IN {"A", "C"}
)