Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
Solved! Go to 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,
Happy to help!
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
Happy to help!
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,
Happy to help!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
7 | |
6 |
User | Count |
---|---|
15 | |
13 | |
11 | |
9 | |
8 |