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 the data. 
Here's the data.

 

 

 

 

 

 

"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

1 Reply

  • 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