topic Simple Calculate Count in DAX Commands and Tips

Simple Calculate Count

adavid999 — Fri, 03 Apr 2020 10:20:16 GMT

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,

Re: Simple Calculate Count

ibarrau — Fri, 03 Apr 2020 12:14:36 GMT

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

Re: Simple Calculate Count

adavid999 — Fri, 03 Apr 2020 12:45:57 GMT

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,

Re: Simple Calculate Count

ibarrau — Fri, 03 Apr 2020 12:50:33 GMT

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,

Re: Simple Calculate Count

adavid999 — Fri, 03 Apr 2020 12:54:38 GMT

Thanks ibarrau for your help. I appreciate it.

Best,