Count multiple criteria same column

[Anonymous]

Hi Experts

how would you count multiple items in the same column??? i am trying the following formula slightly stuck..

Case = CALCULATE(COUNTROWS(Case_Data),Case_Data[CaseType]={"2","61"})

i want to count all case type with the following numbers:

2, 61, 67,68, 80, 112,113

[Anonymous · Accepted solution]

You can either use IN or CONTAISNROW function.

Case = CALCULATE(COUNTROWS(Case_Data),Case_Data[CaseType] IN {"2","61"})

Thansk

Raj

[Anonymous]

Hi Raj...

getting the follwoing error

[MFelix]

Hi @Anonymous,

The error is related with formats you nee to take the "" from your IN sintax, because you are converting the values to text, if your column is a number formatted it will not compare.

The answers provided by @Anonymous, should work.

Regards,

MFelix

[Anonymous]

Thanks for the feedback, appreciated.

[Anonymous]

Right, both should work.

Case = CALCULATE(COUNTROWS(Case_Data),Case_Data[CaseType] IN {2,61})

Case = CALCULATE(COUNTROWS(Case_Data),CONTAINROWS( {2,62,61},Case_Data[CaseType])

Thanks
Raj

[Waall_Ramos]

Good solve @Anonymous 👏👏👏👏👏👏