Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dynamic Rank Order

I'm working with a dataset of 4.5 million entries, spanning 3 years and multiple other criteria that I'd like to slice the data on.  Where I'm struggling is trying to get the financial values to re-r...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

Try this measure

Rank = RANKX(ALLSELECTED('Table'),CALCULATE(SUM('Table'[OM])),,DESC,Dense)

 

 

 

 

Best Regards,

Stephen Tao

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Stephen,

    Thank you for your help with this.  I tested your solution and it works on the test data.  Unfortunately, when I apply it to the full dataset, I'm getting strange results (see below).

     

    This is on the unfiltered data (so, all years 2018-2020).  As you can see, there's a tied rank for #7 and #19, even though the OM values are different.  The rank ordering also skips #13 for no apparent reason.

    Do you have any ideas as to what is causing this?