Forum Discussion

Nats_17's avatar
Nats_17
New Member
1 year ago
Solved

Problem with RANKX while applying top n in filter pane

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[Subc...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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