Forum Discussion
akshay2204
3 years agoFrequent Visitor
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 th...
mlsx4
3 years agoMemorable Member
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