Forum Discussion
SamfarUK
Helper I
Helper IMeasure calculation with more than on element
Can someone please tell me how I can add "OP25R" into this calculation?
SamfarUK , Try using
DAX
Budgets = CALCULATE(
SUM('consolidated'[value]),
KEEPFILTERS('consolidated'[Financial] IN {"OP25", "OP25R"})
)
2 Replies
- bhanu_gautam
Super User
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!
