Forum Discussion
mb0307
Responsive Resident
3 years agoSorting 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
Solution Sage
3 years agoHere'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
Responsive Resident
3 years agoPadycosmos thanks but I am not using TopN.