COUNTROWS While filtering out 2 things

[Anonymous]

I have a table similar to the one below, however I have many more options. I need all but two of those options counted (Critical and Non-Critical Failures). I feel like there's too many to list on their own to put into the calc, plus if we add more, I want them to come in automatically. I just want to filter out the two. This is my current calc, but it doesn't seem to be working: 

Non Fail Cases = COUNTROWS(FILTER('Cases',NOT('Cases'[Support Type] IN ({"Critical Failure","Non - Critical Failure"}))))

ID number	Category
123456	Critical Failure
123457	Critical Failure
123458	Scheduling
123459	Application
123789	Non-Critical Failure
456789	Upgrade

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

Create an independent "Category" table as slicer:

Slicer = distinct('Cases'[Category])

Then modify the measure as below:

Non Fail Cases = CALCULATE(COUNTROWS('Cases'),FILTER('Cases',NOT('Cases'[Support Type] IN VALUES('Slicer'[Category]))))

The result depends on the selected values in the slicer.

Best Regards,

Jay

[MFelix]

Hi @Anonymous ,

In your measure you select the column support type however in the datamockup you call it Category are they the same or is this an error? Another thing that I notice is that you have spaces on the the measures "Non - Critical Failure" and no spaces on the Mockup "Non-Critical Failure"

The measure should work has expected, however the context of the visualization can make it give incorrect numbers, can you provide more context of the error you are getting?