RANKX does not give the expected result

[Syndicate_Admin]

Hello

I'm having trouble pulling a sales ranking (photo attached).

I don't understand why it gives me back several "1s" and several repeated positions. Does Alguie know why that's the case?

Thanks in advance.

[Anonymous]

RANKX(ALL('Table'[Product]),[sum of sale],,DESC,Dense)
You actually called full table instead of product column.

[Anonymous]

Try This:

RANKX(ALL('Table'[Product]),[sum of sale],,DESC,Dense)

[Syndicate_Admin]

Hi haseebsuhail943,

Thanks for your prompt reply, but it didn't work:

[Syndicate_Admin · Accepted solution]

This issue is now solved as the "AdventureWorks" database has duplicated product names with different IDs...