Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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 |
Solved! Go to Solution.
@Ptolemaida , Create a new measure
DAX
Sum_A_and_C =
CALCULATE(
SUM('YourTable'[Actuals]),
'YourTable'[Category] IN {"A", "C"}
)
Proud to be a Super User! |
|
@Ptolemaida , Create a new measure
DAX
Sum_A_and_C =
CALCULATE(
SUM('YourTable'[Actuals]),
'YourTable'[Category] IN {"A", "C"}
)
Proud to be a Super User! |
|