Forum Discussion
Using COUNTA with exceptions
I created a mock file to try and recreate what you're trying to do got this code to work. I put the IN {"E0","E17"} inside the NOT which made it calculate for each column separatly, so I hope this works for you as it did for me.
Total Errors =
CALCULATE(
COUNTA('Excel_GVRT (2)'[Error Code]) + COUNTA('Excel_GVRT (2)'[2nd Error Code]) + COUNTA('Excel_GVRT (2)'[3rd Error Code])
,FILTER(
ALL('Excel_GVRT (2)')
,NOT('Excel_GVRT (2)'[Error Code] IN {"E0","E17"}) || NOT('Excel_GVRT (2)'[2nd Error Code] IN {"E0","E17"}) || NOT('Excel_GVRT (2)'[3rd Error Code] IN {"E0","E17"})
)
)
Ok it's working, but it's just counting all the errors. The total error count is 9223 and whatever I include as a row e.g. Region, or Team, every line says 9223.
Do you have an email address I can send you a screenshot or share my report with you?
Annoyingly I could do this on Excel but i'm trying not to use it for reporting!
Jemma :-)
You can actually upload photos or files in these forum messages but if don't want to post your personal stuff like I understand and can do it through messaging if you like.