Forum Discussion
Solved
Need a formula for count not equal to a value
Hello, I am trying to create a formula in dax where i am using the count function or variation of. data table = current Field name = area I am looking for the total number of entries where ...
Try the following formula, I think this should help you out.
Count Area= CALCULATE(COUNTROWS(current), FILTER(current,current[area] <> "No Defect"))
What about if you wanted to count excluding mulitple "Values"? I have columns for A, B, and C. I need one for "Other" to count anything else in the column that's not A, B, or C.
- Ashish_Mathur
Super User
Hi,
Share a dataset and show the expected result.
