Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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 ...
Need Help
  • TomMartens's avatar
    TomMartens
    9 years ago
    My fault you have to use curly braces {...} instead of (...)

    Regards
Anonymous's avatar
Anonymous
Not applicable
9 years ago

i  just have the solution for this case..

 

Measure 3 = CALCULATE([TotalExaminations];
Examinations[exa_StatusID] = "WAI" ||
Examinations[exa_StatusID] = "VER" ||
Examinations[exa_StatusID] = "APP" ||
Examinations[exa_StatusID] = "HEL" ||
Examinations[exa_StatusID] = "SCH" )

 

Thanks anyway guys!

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks for sharing the solution and it resolved my needs.