CountRows

[MacyMolly]

Hi Everyone,

Need your help on this. I'm trying to compare each value and count if it's less than, but it's not giving me the correct count. Any help is much appreciated. I have shared a link for the data. 
Here's the data.

[Dangar332 · Accepted solution]

hi, @MacyMolly 
 i think in your code it count blank row also if blank row present in your data
try below measure

count =

 var curr = MAX(Sheet1[HMI])

 return

 COUNTX(FILTER(ALL(Sheet1),Sheet1[HMI]<curr),Sheet1[HMI])

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly. Appreciate your kudos