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
    )

Sean's avatar
Sean
Community Champion
10 years ago

Rymatt830 Check which [ID] column you are using to build your Table Visualization?

 

If your Ranking Measure look like this...

 

you should use tblOrganization[ID] to build your Table NOT tblFinancialAudit[ID]

 

Rank =
RANKX (
    ALL ( tblOrganization[ID] ),
    CALCULATE ( SUM ( tblFinancialAudit[CurrentAssets] ) )
)

 

I hope this resolves it! :smileyhappy:

Rymatt830's avatar
Rymatt830
Advocate II
10 years ago

Thanks for the reply. I tried that solution initially and it does not work.