https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sort-matrix-by-measure-but-2nd-level-rows-ignore-sort/m-p/3067550#M106275 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="15990" data-lia-user-login="codyraptor" class="lia-mention lia-mention-user">codyraptor</a> , If sort of volume, it should sort ascending or descending at each level based on volume </P> <P>&nbsp;</P> <P>But if you sort on Column- the company then it will follow the sort order</P> Wed, 08 Feb 2023 02:08:00 GMT amitchandak 2023-02-08T02:08:00Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sort-matrix-by-measure-but-2nd-level-rows-ignore-sort/m-p/3067225#M106251 <P>Hey everyone.&nbsp; I have a simple matrix that sorts by volume.&nbsp; I also have a time calculation group for Current and PY and the ordinal is set to the correct sort order.&nbsp; However...sorting the Matrix overrides the sort order of the calculation group.&nbsp; Is there a way to sort the matrix by the volume measure...but ignore the sort for the calculation group?&nbsp;&nbsp;</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Tue, 07 Feb 2023 21:42:13 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sort-matrix-by-measure-but-2nd-level-rows-ignore-sort/m-p/3067225#M106251 codyraptor 2023-02-07T21:42:13Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sort-matrix-by-measure-but-2nd-level-rows-ignore-sort/m-p/3067550#M106275 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="15990" data-lia-user-login="codyraptor" class="lia-mention lia-mention-user">codyraptor</a> , If sort of volume, it should sort ascending or descending at each level based on volume </P> <P>&nbsp;</P> <P>But if you sort on Column- the company then it will follow the sort order</P> Wed, 08 Feb 2023 02:08:00 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sort-matrix-by-measure-but-2nd-level-rows-ignore-sort/m-p/3067550#M106275 amitchandak 2023-02-08T02:08:00Z