index table in DAX based on Sales

[cosminc]

Hi all,

i have a simple table like below and i need to add an index based on descending order of Sales

Salesmen   Sales

George          10

Ana                50

Jane               30

and need

Salesmen   Sales    Index

George          10         3

Ana                50         1

Jane               30          2

can you help me with this?

Thanks,

Cosmin

[PattemManohar · Accepted solution]

@cosminc  Please try this as a New Column

Index = RANKX(Test294Rank,Test294Rank[Sales],,DESC)

[cosminc]

Thanks!

Cosmin