RANKX is not giving rank number sequentially

[sarvesh23p]

Hi All,

I am trying to find out the Rank of Countries vs Order Quantity usinf RANKX but the rank are not showing up inn sequence.

Rank of Order Products = RANKX(All(SalesTerritory),SalesTerritory[Total Quantity],,ASC)

Total Quantity = SUM(Sales[Order Quantity])

[sarvesh23p]

Hi @tackytechtom,

I did try using Dense but it didn't worked.

[tackytechtom]

Hi @sarvesh23p ,

Ok... Can you share your file or the data?

Thanks!

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[tackytechtom]

Hi @sarvesh23p ,

Does it help to add "DENSE" to your formular?

Rank of Order Products = RANKX(All(SalesTerritory),SalesTerritory[Total Quantity],,ASC, DENSE)

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/