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"))
v-jiascu-msft
Microsoft Employee
Microsoft Employee