Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |