Forum Discussion
mb0307
3 years agoResponsive Resident
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? DOWNLOAD - DATA AND PBIX FILE Thank you in advance...
Padycosmos
3 years agoSolution Sage
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
- mb03073 years agoResponsive Resident
Padycosmos thanks but I am not using TopN.