Forum Discussion
Rankx with duplicate rows
I found the solution based on the article :
Power BI – Handling Duplicate Rankings Using the R... - Microsoft Power BI Community
First of all, I had too many duplicates that were polluting the results.
So I took the table and made a reference.
Then I removed the nulls that were creating a lot of duplicates, I applied the filters for the ranking directly on the table.
Then I created an indexAfter that I created a column :
Rank = rankx(Filter(table,myfield = Earlie(myfield)), date, , ASC, Dense)
Rank corrected = rankx(Filter(table,myfield = Earlier(myfield)),myfield + index/power(10,5)), ,ASC, Dense
Hello,
Little update.
Here is the expected result :
I try a new link but its not working : Power BI – Handling Duplicate Rankings using RANKX DAX Function | LinkedIn
and this one : Solved: Rankx = struggling with duplicates values - Microsoft Power BI Community
Perhaps I make a mistake...
I found the solution based on the article :
Power BI – Handling Duplicate Rankings Using the R... - Microsoft Power BI Community
First of all, I had too many duplicates that were polluting the results.
So I took the table and made a reference.
Then I removed the nulls that were creating a lot of duplicates, I applied the filters for the ranking directly on the table.
Then I created an index
After that I created a column :
Rank = rankx(Filter(table,myfield = Earlie(myfield)), date, , ASC, Dense)
Rank corrected = rankx(Filter(table,myfield = Earlier(myfield)),myfield + index/power(10,5)), ,ASC, Dense