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.
Community ChampionI created a calculation called Sequential once, but this is going to depend on what is in your table, can you share that or an example?
https://community.powerbi.com/t5/Quick-Measures-Gallery/Sequential/m-p/380231
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Post PatronIt is very simple. I have a column TOTAL sorted descending. Next to it I need an index starting with 1.
The table is created with DAX so I can't do it with query editor.
Giora
See if this solution helps:
https://community.powerbi.com/t5/Desktop/Add-calculated-index-column-by-DAX/td-p/72448
- gtamir
To my understanding it is a Rank. I want a simple index 1 up to the last row.
I'd like to have this:
- Greg_Deckler
Oh, well that's super easy, you just need to add a column like this:
Index = RANKX(ALL('Table20'),[NetTotal])