Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 the 5 largest values.
I was then asked to put 2 specific typologies at the end of the table, so I created an INDEX column which allowed me to set a value to 1 by default and 1000, 1001 on the one to be at the end.
Once the INDEX value is set I configure the sort:
Then here is my measurement which allows me to have the RANK:
Solved! Go to Solution.
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 🙂
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 🙂
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
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |