Forum Discussion
Solved
Rankx is Incorrect when similar ranked column added to table
I'm using RANKX to rank the number of "Monthly Lines" based on a column called "Parent and TC City". The above rank work fine. If I add the field "Parent Org" to the table, then the ranking i...
Would something like this help?
Rank TC Parent City 2 = RANKX( ALL( 'Table'[Parent and TC City], 'Table'[Parent Org] ), [Monthly Lines] )It seems to work in both of your scenarios.
Let me know how this works.
pbix: Rankx Problem.pbix
lbendlin
Super User
Super UserPlease provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
I posted the link to the Power BI that shows the problem - Thanks