Forum Discussion
How to use filter with multiple values in DAX?
Hello guys, I am trying to create a measure TotalExaminationBacklog which counts all the examinationsIDs with the status WAI, VER, APP, HEL and SCH. But it seems that my measure (see image ...
- My fault you have to use curly braces {...} instead of (...)
Regards
Thank you for this answer - specifically related to using "in ("value", "value", "value", . . .)".
I was struggling to find an alternative to using || and "or"
I did notice in my query I needed to modify the syntax by using a curly bracket because the system would not accept the parentheses:
4_Stage_Count = CALCULATE(COUNT(Opportunities[AccountId]),Opportunities[Stage] in {"Closed Won", "Closed Lost"})
Let me know if anyone knows why the () had to be replaced by the {}.
mculloa {} are required to indicate that you are creating a list of items.