Forum Discussion
Solved
ContainsString with OR function
Hi there - PowerBi newbie here: Could anybody highlight the error in my DAX expression below: No of people with retakes = CALCULATE(DISTINCTCOUNT('people (2)'[Person ID]), FILTER('auditlogs ...
Could you try:
No of people with retakes = CALCULATE(DISTINCTCOUNT('people (2)'[Person ID]), FILTER('auditlogs all',CONTAINSSTRING('auditlogs all'[Description], "Sent Retake") || CONTAINSSTRING('auditlogs all'[Description], "Sent Redo")))The "||" operator represents OR in DAX. "&&" can be used for AND
This worked - thank you!