Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Filter OR condition

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

Need Help
  • freginier's avatar
    freginier
    4 years ago

    Try this

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

1 Reply

  • freginier's avatar
    freginier
    Solution Sage
    4 years ago

    Try this

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