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:

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hello Vvelarde,

 

I'm using the same formula for my Rank measure and I don't know why but it doesn't seem to work properly..

The rank starts from 2.. look

 

 http://prntscr.com/e5m25q

 

 (I don't know why I can not send the screenshot as a picutre in the post...)

 

Thanks