Forum Discussion
Rankx with duplicate rows
Hello dear community,
I have a problem with the ranking.
I have a table with duplicate data,
People who have made interventions per day.
I try to have a ranking to be able to make other measurements.
I tried the expression rankx, as well as other articles from here including this one which I thought would help me but as you see it is not the case.
I should have seen the closest date to 01/01/2022 in number 1 and not 16...
You will find a sample of data below.
Can you help me?
Thanks
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
2 Replies
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 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