Sorting Top 5

[mb0307]

Hi all,

I am showing % difference in a matrix table. 

How can I sort top 5 Products based on another measure, see below?

DOWNLOAD - DATA AND PBIX FILE

Thank you in advance.

[mb0307]

Can anyone help with this please?

[Padycosmos]

Hope this helps:

[mb0307]

@Padycosmos thanks again but this is not the requirement.  Please read my post and files. 

[Padycosmos]

Add the measure diff to tooltips and then click on the ellipsis and select descending and diff

This video illustrates that

https://www.youtube.com/watch?v=1bp_e-ik7aA

[mb0307]

it doesn't work for Tables and Matrix unfortunately. 

[Padycosmos]

Here's an excerpt from a Microsoft document on TOPN() wherein it is stated that the result is not sorted in any order. So apparently, sorting has to be done manually : https://learn.microsoft.com/en-us/dax/topn-function-dax

[mb0307]

@Padycosmos  thanks but I am not using TopN.  

[lucadelicio]

I think you have to built a calculated column with a RANKX and use it to order. But you have to pay attention to the circular dependency. If i have time a try to help you in the next day.

[mb0307]

@lucadelicio thanks, please see if you can help with this one. As i am not sure how to do this. 

[mb0307]

Can anyone help please?

[lucadelicio]

Is this what you need?

[mb0307]

@lucadelicio  No my friend.  Please read the instruction in the PBIX

The Accuracy % table should show SKU in this order: 

Thanks.