Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |