Forum Discussion

PaulBethancourt's avatar
PaulBethancourt
Frequent Visitor
3 years ago
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...
Need Help
  • grantsamborn's avatar
    grantsamborn
    3 years ago

    Hi PaulBethancourt 

    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