Forum Discussion

adavid999's avatar
adavid999
Helper V
6 years ago
Solved

Simple Calculate Count

Hi, a simple question hopefully. I have a column with IDs ranging from 1-15. What is the correct DAX if I want to count just those data with ID <=5 and between 8-10?

 

I was trying =CALCULATE(COUNT(Table[ID]),Table[ID] <=5,Table[ID]>=8,Table[ID]<=10) - but I see this isn't correct?!

 

Thanks,


A

 

  • ibarrau's avatar
    ibarrau
    6 years ago

    Hey. Yes, that will work for your actual condition. First asking it can be <=5 OR >=8 is something that will put the number in one spot and then you add a second mandatory condition that won't break the previous one saying it has to be <=10.

    The first post won't work because the conditions in and are not correlative. You can't ask the engine you want a value <5 and >8 at the same time. It's one or the other.

     

    Regards,

4 Replies

  • ibarrau's avatar
    ibarrau
    Super User
    6 years ago

    Hi. I don't think it will work like that. You need to attach those conditions as one. If you just add conditions with "commas" in calculate, those are "AND" one by one. Try this instead:

     

    CALCULATE(
    COUNT(Tabla[ID]);
    OR(
        AND(Tabla[ID]>=8 ; Tabla[ID]<=10);
        Tabla[ID] <=5
    )
)

     

    Hope this helps,

    Regards

    • adavid999's avatar
      adavid999
      Helper V
      6 years ago

      Thanks ibarrau that looks like it works. Playing around, I see this also gets same result as your method:

       

      =CALCULATE(COUNT(Table[ID]),Table[ID]<=5 || Table[ID]>=8,Table[ID] <=10)

       

      May I ask if that also looks OK to you or is it a coincidence that this gets same result?

       

      Many thanks,

      A

      • ibarrau's avatar
        ibarrau
        Super User
        6 years ago

        Hey. Yes, that will work for your actual condition. First asking it can be <=5 OR >=8 is something that will put the number in one spot and then you add a second mandatory condition that won't break the previous one saying it has to be <=10.

        The first post won't work because the conditions in and are not correlative. You can't ask the engine you want a value <5 and >8 at the same time. It's one or the other.

         

        Regards,