RANX does not allow for a filter of greater than or equal to

[datadelta]

I have a RANKX command that works for ranking sales by store.  However, when I set the parameters to equal or greater to 35, the results change the rank to 1 - 34 rather than showing the associated stores as ranked 35 and higher.

Not sure why it's doing this.  It has worked previously so I don't know why it's not working now.

[Anonymous]

Hi @datadelta 

After my testing, I have not encountered a situation like yours.

Here is my testing:

My sample:

I created two measure as follow.

sum = SUM('Table'[sales])

Measure = RANKX(ALL('Table'), [sum], , ASC, Dense)

Result:

If my testing that is very different from yours, please do not hesitate to mention it and I will modify it. If possible, could you tell me what you did? Did you perform any other operations before the error occurred? Please remove any sensitive data in advance. Thank you!

Best Regards,
Yulia Xu

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

[datadelta · Accepted solution]

I solved this. I had blank rows and that was throwing the calc off.

thanks for you response!