Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
julied
Frequent Visitor

COUNTIF equivalent in DAX using mathematical operators

I'm trying to create a measure in PowerBI that will do the same thing as this Excel formula:

=COUNTIF(J2:J378,"<=7")/COUNT(J2:J378)

 

Basically, I have a column with values for the number of days of completion and I'm trying to calculate the percentage that were completed in 7 days or less.

 

The denominator works fine; it's the numerator of the formula that won't work.

 

I have this measure for the numerator: Tim7Days = COUNTAX('Timeliness Query','Timeliness Query'[R2CinDays]<=7), but it keeps ignoring the "<=7" and giving me a total count.

 

I tried adding in FILTER functionality like I've seen elsewhere on community posts, but it just gives me error messages about multiple columns and scalar values. All the samples I see match text rather than use greater than or less than.

 

 

 

1 ACCEPTED SOLUTION
Zubair_Muhammad
Community Champion
Community Champion

Hi @julied

 

Try this one

 

Tim7Days =
COUNTROWS ( FILTER ( 'Timeliness Query', 'Timeliness Query'[R2CinDays] <= 7 ) )

View solution in original post

2 REPLIES 2
Zubair_Muhammad
Community Champion
Community Champion

Hi @julied

 

Try this one

 

Tim7Days =
COUNTROWS ( FILTER ( 'Timeliness Query', 'Timeliness Query'[R2CinDays] <= 7 ) )

Yes, that worked! Thank you.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.