Forum Discussion
Change default sort by Total in Matrix
Hello, I have the following matrix and I sorted it by the value MAT TY, but it is sorted default by the Total Column. How can I sort it by the 'Store 2' column for example? I already have the Sto...
Hi,
Thank you all for your reply! I understand that it is not possible to order by a specific measure in Matrix.
Would it be possible if I create a Rank? I've tried several variants, but I get only value '1' for all stores.
Thank you!
Anonymous
Ranking is, IMO one of the most tricky aspect regarding DAX.
Most of the time I get "1" for RANKX results, it's because my relationships aren't correct. Perhaps that's why it doesn't work for you.
Also, consider perhaps another visual, such as a regular table instead of your matrix, to sort the columns.