Filter OR condition

[Anonymous]

Hi all,

I am trying to use Calculate and filter with an OR condition

Like this CALCULATE(DISTINCTCOUNT[LIST]),FILTER(Table,[Status], OR([Status]<>"Yes",[Status]<>"Maybe"))

Any ideas on how to make it work?

thank you

[freginier · Accepted solution]

Try this

CALCULATE(DISTINCTCOUNT[LIST]),NOT([Status] in {"Yes","Maybe"}))