Problem with RANKX while applying top n in filter pane

[Nats_17]

Hello!
I'm experiencing some trouble with my report. I have the following measures:

Total Gross Profit = SUM(Dane[Order Gross Profit])

and

Subcategory Rank =

RANKX(

    ALL(Dane[Subcategory Name]),  

    [Total Gross Profit], 

    ,

    DESC 

)

when i create a matrix visual with all subcategories, the ranks are correct, as shown below:

However when i go to the filter pane and filter subcategories to top 5 by total gross profit:

something weird happens:

I would like to see subcategory rank as before applying the top n filter.
I have no idea how to fix it and would really appreciate some support.

[Anonymous · Accepted solution]

Hi @Nats_17 ,
Thanks for Ashish_Mathur reply.
Here is another way to troubleshoot this

You can use the ranked MEASURES as a basis to get the top five profits, as shown below, and you can display the last five figures in sub-sort order

If you still can't solve the problem, you can provide the full example data so we can help you faster. Please hide sensitive information in advance.

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Ashish_Mathur]

Hi,

In your measure, change ALL to ALLSELECTED