Forum Discussion

Rymatt830's avatar
Rymatt830
Advocate II
10 years ago
Solved

RANKX Help

I can't seem to get the RANKX function to work. I have searched what I think is every other post and tried all the solutions but nothing has worked. I am trying to return the annual rank by peer grou...
Need Help
  • Vvelarde's avatar
    Vvelarde
    10 years ago

    Ranking =
    RANKX (
        FILTER (
            ALL ( tblFinancialAudit );
            tblFinancialAudit[year] = EARLIER ( tblFinancialAudit[Year] )
                && tblFinancialAudit[PeerGroup] = EARLIER ( tblFinancialAudit[PeerGroup] )
        );
        tblFinancialAudit[CurrentAssets];
        ;
        ASC;
        DENSE
    )

Vvelarde's avatar
Vvelarde
Community Champion
10 years ago

Ranking =
RANKX (
    FILTER (
        ALL ( tblFinancialAudit );
        tblFinancialAudit[year] = EARLIER ( tblFinancialAudit[Year] )
            && tblFinancialAudit[PeerGroup] = EARLIER ( tblFinancialAudit[PeerGroup] )
    );
    tblFinancialAudit[CurrentAssets];
    ;
    ASC;
    DENSE
)

Rymatt830's avatar
Rymatt830
Advocate II
10 years ago

Thank you again, Vvelarde! Your solution works great!