Measure calculation with more than on element

[SamfarUK]

Can someone please tell me how I can add "OP25R" into this calculation?

[bhanu_gautam · Accepted solution]

@SamfarUK , Try using

DAX
Budgets = CALCULATE(
SUM('consolidated'[value]),
KEEPFILTERS('consolidated'[Financial] IN {"OP25", "OP25R"})
)

[SamfarUK]

I knew it was going to be something simple but I just couldn't figure it out. Thank you so much!