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
When filtering on the ID's try the following:
OR(
Explanations[StatusID] = "WAI",
Explanations[StatusID] = "VER",
Explanations[StatusID] = "APP", etc.
)
I think the way you have it, you are concatenating all the values into 1 string, which doesn't exist.