topic Re: How to filter out 2 options from a list, and count the remainder in DAX Commands and Tips

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

Anonymous — Tue, 21 Apr 2020 15:13:20 GMT

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

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

camargos88 — Tue, 21 Apr 2020 15:32:19 GMT

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

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

Anonymous — Tue, 21 Apr 2020 16:47:08 GMT

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.

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

Anonymous — Sat, 15 Aug 2020 21:35:43 GMT

Hi Anonymous ,

Please let me know if the solution workd for you.

Regards,

Harsh Nathani