Forum Discussion
Sort by measure value
Hi There
I have a matrix below with all columns from a single table Query1
Measure DevShare = IF(SUM(Query1[Order Demand -1])=0,"NoDemand",SUM(Query1[Cons ABS -1])/CALCULATE(SUM(Query1[Cons ABS -1]),ALL(Query1[Material]))*(1-CALCULATE(1-SUM(Query1[Cons ABS -1])/SUM(Query1[Order Demand -1]))))
I want to sort by it in a desc. manner, but can't find any buttons in the header or format area.
Thanks!
4 Replies
Hi, Anonymous
Try click on header DevShare to sort.
Currently is sorted by first header column (MonthDate WWB and there is an arrow up). You can click twice to sort ASC or DESC
Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.
Appreciate your Kudos !!!
Hi Anonymous ,
According to your description, in matrix visual, to sort the actual field or measure, just hover over the column name, the arrow down indicates descending order and the arrow up indicates ascending order.
Or click on the top right corner of the "..." to sort the specific fields which also include the measures added to the matrix
If the problem is still not resolved, please point it out. Looking forward to your feedback.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
