Forum Discussion

alefebvre's avatar
alefebvre
New Member
5 years ago
Solved

Ranking error (sort column)

Hello, I must put the number of typologies per group, and then do the top 5 typologies. With some research I ended up finding the RANKX function which thanks to a filter <= 5 allows me to display t...
Need Help
  • alefebvre's avatar
    alefebvre
    5 years ago

    Hello,

    Thank you for your help, I think it does not work for me because I go through a measure to count the number of typologies.

     

    I found a solution on this site : https://www.sqlbi.com/articles/use-of-rankx-in-power-bi-measures/

     

    Here is what I did in the method RANKX : TYPO RANG = RANKX( ALL(TYPOLOGIES[Index], TYPOLOGIES[TYPO]), MESURES[TYPO COUNT], , DESC)

     

    Have a good day 🙂

alefebvre's avatar
alefebvre
New Member
5 years ago

Hello,

Thank you for your help, I think it does not work for me because I go through a measure to count the number of typologies.

 

I found a solution on this site : https://www.sqlbi.com/articles/use-of-rankx-in-power-bi-measures/

 

Here is what I did in the method RANKX : TYPO RANG = RANKX( ALL(TYPOLOGIES[Index], TYPOLOGIES[TYPO]), MESURES[TYPO COUNT], , DESC)

 

Have a good day 🙂