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
    )

Rymatt830's avatar
Rymatt830
Advocate II
10 years ago

Thank you, Vvelarde. I implemented your suggestion (except I replaced ";" with ",") but it's not recognizing the PeerGroupAC field. There are only 21 organizations in that Peer Group, but the ranks appear to be based on all of the organizations, not just the one's in the selected group (see image)

 

 

 

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.

  • 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