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