Rankx not working properly!

[JEM_Systems]

Hi, I have this Formula to try to return a Ranking for this table, but isn't on the right order, it should have just 1, 2 , 3 and 4 , not 40,41,41 and etc. Could someone help me.

[mlsx4 · Accepted solution]

Hi @JEM_Systems 

I would recommend you to take a look at this: https://data-mozart.com/static-vs-dynamic-ranking-in-power-bi/

You will probably solve your problem