Forum Discussion
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...
Hi Nats_17 ,
Thanks for Ashish_Mathur reply.
Here is another way to troubleshoot thisYou 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 HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi,
In your measure, change ALL to ALLSELECTED