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.
Hi,
I'm trying to display the first 10 ROWS of filtered data sorted by Score value in descending order which contains duplicate values. I have tried TOPN, RANKX and a combination of both in a measure with no luck.
This is the table visual, I only wish to see the FIRST 10 rows of Score data, not the first 10 varied Score values (if the highest scores were 5x level 16 and 6x level 15, I only want to display the 5x level 16 and the first 5 level 15, preferably also by Impact £ in descending order).
This is what I have -
This is what I'm trying to achieve -
Can anyone help?
Solved! Go to Solution.
@IvanCM , In case you are facing issues because of the same values. You need to use a rank tie breaker
refer
https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale // Also discussed here
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...
@IvanCM , In case you are facing issues because of the same values. You need to use a rank tie breaker
refer
https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale // Also discussed here
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...
Awesome! Thank you!
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 |
---|---|
105 | |
96 | |
79 | |
67 | |
62 |
User | Count |
---|---|
137 | |
106 | |
104 | |
81 | |
63 |