Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Try this
CALCULATE(DISTINCTCOUNT[LIST]),NOT([Status] in {"Yes","Maybe"}))
Try this
CALCULATE(DISTINCTCOUNT[LIST]),NOT([Status] in {"Yes","Maybe"}))
User | Count |
---|---|
98 | |
91 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |