Simple Calculate Count

[adavid999]

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]

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]

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 · Accepted solution]

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,

[adavid999]

Thanks @ibarrau for your help. I appreciate it.

Best,

A