Forum Discussion
Solved
Filtering visual with multiple criteria
Hi I have a visual which basically shows this (sales for each department and status of approval, only for the last three days): Department No. Of Sales Status Date Dept. 1 8 Approved ...
MadBern85 You seem to need a Complex Selector: The Complex Selector - Microsoft Power BI Community
Maybe:
Selector Measure = VAR __Yesterday = TODAY() - 1 RETURN SWITCH(TRUE(), MAX([Date]) = __Yesterday,1, MAX([Status] = "Not approved",1, 0 )
MadBern85 You seem to need a Complex Selector: The Complex Selector - Microsoft Power BI Community
Maybe:
Selector Measure =
VAR __Yesterday = TODAY() - 1
RETURN
SWITCH(TRUE(),
MAX([Date]) = __Yesterday,1,
MAX([Status] = "Not approved",1,
0
)Thanks a bunch, that seemed to do the trick! Only had to add the missing ")" after the second MAX statement.
Regards
MadBern
MadBern85 Ah yes, the syntax... 🙂
