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.
Hi,
I have used rankx function to calculate the top customers by GM Impact. I need to show top 5 customers
As you see in this image 1 when no filter is selected from filter pane we can see all the ranks
But as I select top 5 using Rank_Gm measure then I can only see 4 records I need to see 5 records
The dax used for rankx is as follows
Hello @akshay2204 use TOP N in advanced filtering option. This will solve your problem.
Hi @akshay2204 ,
If the problem has not been resolved, would you like to provide the pbix without sensitive data, I can't reproduce the problem.
Best regards,
Community Support Team_yanjiang
Hi @akshay2204
Maybe your problem is that it is counting the total as one row (even if you have hidden it). Here is a possible solution: https://community.fabric.microsoft.com/t5/Desktop/RANKX-for-Top-5-Facilities-by-number-of-successes/...
User | Count |
---|---|
76 | |
74 | |
61 | |
61 | |
45 |
User | Count |
---|---|
108 | |
103 | |
93 | |
83 | |
64 |