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 🙂

v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
5 years ago

Hi alefebvre ,

Could not reproduce it in my side. How did you create the index column and the [TYPO COUNT] measure?

Could you please consdier sharing more details about it or a simple sample file without any sesentive information for further discussion?

 

Attached my test sample file in the below, you can also change it based on the sample file.

 

Best Regards,
Community Support Team _ Yingjie Li