Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Count multiple criteria same column

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"})  ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    You can either use IN or CONTAISNROW function.

     

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

     

    Thansk

    Raj

MFelix's avatar
MFelix
Super User
8 years ago

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's avatar
Anonymous
Not applicable
8 years ago

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's avatar
    Waall_Ramos
    New Member
    4 years ago

    Good solve Anonymous 👏👏👏👏👏👏