Forum Discussion
Post PatronHow can I create a simple index column with dax.
Yep it works. Thanks
gtamir - Oh, then you want my SuperRank column formula, which I just invented:
SuperRank = VAR __table = FILTER(ALL('Table6'),[Total] > EARLIER('Table6'[Total])) VAR __tableSame = FILTER(ALL('Table6'),[Total] = EARLIER('Table6'[Total]) && [Customer] < EARLIER(Table6[Customer])) RETURN COUNTROWS(__table) + 1 + COUNTROWS(__tableSame)Attaching PBIX, you want Table6.
gtamir That is correct as written. You have to have some secondary identifier, you cannot just magically assign the ranks when things tie. You could use actual Index column in your query and then use that as your secondary identifier and that would ensure that you would never get the same rank twice.
Post PatronGreg_Deckler Greg, just now I noticed that RANKX ranks the same value as the same rank. I need something like row number.
Community Championgtamir - Oh, then you want my SuperRank column formula, which I just invented:
SuperRank =
VAR __table = FILTER(ALL('Table6'),[Total] > EARLIER('Table6'[Total]))
VAR __tableSame = FILTER(ALL('Table6'),[Total] = EARLIER('Table6'[Total]) && [Customer] < EARLIER(Table6[Customer]))
RETURN
COUNTROWS(__table) + 1 + COUNTROWS(__tableSame)
Attaching PBIX, you want Table6.
- Greg_Deckler
gtamir That is correct as written. You have to have some secondary identifier, you cannot just magically assign the ranks when things tie. You could use actual Index column in your query and then use that as your secondary identifier and that would ensure that you would never get the same rank twice.
MAAbdullah_47Helper V
Hi Greg_Deckler
Please note that (Earlier) Is not supported by DAX now , try to check another solution.
- gtamir
Thank you for the quick response. I'll try it and try to understand..
I'll let you know.
- gtamir
Greg_Deckler It works BUT, if there are two identical names the index will be the same.
- lbendlin
Super User
It's still supported but it is deprecated. Use variables instead.
🙂 Good one!
