Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

CountRows

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...
"Need Help"
  • Dangar332's avatar
    Dangar332
    2 years ago

    hi, Anonymous 
     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
Dangar332's avatar
Dangar332
Resident Rockstar
2 years ago

hi, Anonymous 
 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