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

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

Hi Raj...

getting the follwoing error

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thanks for the feedback, appreciated.