Forum Discussion
Sorting Top 5
Hi all,
I am showing % difference in a matrix table.
How can I sort top 5 Products based on another measure, see below?
Thank you in advance.
12 Replies
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.
lucadelicio thanks, please see if you can help with this one. As i am not sure how to do this.
Is this what you need?
lucadelicio No my friend. Please read the instruction in the PBIX
The Accuracy % table should show SKU in this order:
Thanks.
Can anyone help please?
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
Padycosmos thanks but I am not using TopN.
Hope this helps:
Add the measure diff to tooltips and then click on the ellipsis and select descending and diff
This video illustrates that
Can anyone help with this please?
