Forum Discussion
RankX
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
3 Replies
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/m-p/73709
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
Hello akshay2204 use TOP N in advanced filtering option. This will solve your problem.
