Forum Discussion
Simple Calculate Count
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,
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
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
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,
