RankX

[akshay2204]

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

Rank Gm =

 RANKX(ALLSELECTED(Sales[Customer]),[GM_Imp],,Desc,Dense)

[Anonymous]

Hello @akshay2204  use TOP N in advanced filtering option. This will solve your problem.

[v-yanjiang-msft]

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

[mlsx4]

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/...