Forum Discussion

SammyPub's avatar
SammyPub
Frequent Visitor
5 years ago
Solved

Rank strange behavior

Hi,   What am I doing wrong?   Problem 1: Why there are repeated ranks? Two 4th, 7th, 15th, ...   The rank and grade measures:     Rank = Var n=COUNT('Resultados'[I...
Need Help
  • SammyPub's avatar
    SammyPub
    5 years ago

    Hi,

    I just solve the problem. I used an old version of the pbix, and made a copy-paste of all the new visuals from newer pbix to the older pbix and now is working correctly

    Thanks

amitchandak's avatar
amitchandak
Super User
5 years ago

SammyPub , first all simply try rank like

 

RANKX(ALL('tblCodsDistrito'[Distrito]), [Grade], ,desc, dense)

or

RANKX(ALLSELECTED('tblCodsDistrito'[Distrito]), [Grade], ,desc, dense)

SammyPub's avatar
SammyPub
Frequent Visitor
5 years ago

It's better but isn't ok.

 

To the Porto region the ranks are always one more than it should be:

As you can see, selecting only the year 2019, Porto has the rank #2

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi SammyPub ,

    In order to do a problem tracking, could you please provide some sample data in the four tables involved? Not sure if it is because the relationship setting and the data in the table affect the result of the rank. In addition, could you please use data examples to illustrate the correct rank value? Thank you.

    Best Regards