How to filter out 2 options from a list, and count the remainder

[Anonymous]

I have a list of case record types. I need a total # of cases that does not include 2 values (Cricital Failure and Non - Critical Failure). I want to be able to total the cases that do not include failures, in the example below, the total would be 3. I have stumbled quite a few times trying to figure this out. Any suggestions? 

Case Number	Date/Time Opened	Support Type
123456	1/1/19	Critical Failure
123457	1/1/19	Critical Failure
123458	1/1/19	Data
123459	1/2/19	Account Maintenance
123460	1/3/19	Non - Critical Failure
123461	1/4/19	Product/Technical

[harshnathani]

Hi @Anonymous 

You can use the below measure.

Count of Cases =

COUNTROWS(

FILTER(

Data16,

NOT(Data16[Support Type] IN ({"Critical Failure","Non - Critical Failure"})

)

)

)

Data16 will correspond to the Name of your Table.

[harshnathani]

Hi @Anonymous ,

Please let me know if the solution workd for you.

Regards,

Harsh Nathani

[camargos88]

Hi @Anonymous ,

Try creating this measure:

Qtd Cases = CALCULATE(COUNT('Table'[Support Type]); FILTER(ALL('Table'); NOT 'Table'[Support Type] IN {"Critical Failure";"Non - Critical Failure"}))

Ricardo