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

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 👏👏👏👏👏👏