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"})

 

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

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

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

6 Replies

  • 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