Forum Discussion

julied's avatar
julied
Frequent Visitor
8 years ago
Solved

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 ...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi julied

     

    Try this one

     

    Tim7Days =
COUNTROWS ( FILTER ( 'Timeliness Query', 'Timeliness Query'[R2CinDays] <= 7 ) )
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Hi julied

 

Try this one

 

Tim7Days =
COUNTROWS ( FILTER ( 'Timeliness Query', 'Timeliness Query'[R2CinDays] <= 7 ) )
julied's avatar
julied
Frequent Visitor
8 years ago

Yes, that worked! Thank you.