Forum Discussion

ruxandraalina's avatar
ruxandraalina
Icon for Helper I rankHelper I
3 years ago

Order by measure within SWITCH

Hello, 

 

I have a bit of an issue with a matrix and hopefully someone could help. 

 

I have created a matrix that shows various measures (created tickets, open tickets, closed tickets, etc.) by support group.

All of these measures have been created using a single SWITCH function, because the customer requested these measures to be split by category (measures related to volumes, to aging and to last update), as below:

 

The customer would like to sort these numbers by tickets open. Given how this whole measure is being constructed, I can't use the classic sort by button. 

 

Is there any way this could be achieved without adding an additional measure for open tickets and then hiding it?

 

Thank you!

Ruxandra

 

Need Help

1 Reply

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi ruxandraalina ,

    Have you tried to create a calculated column in the same order as the measure then sort the OperationGroup column by the new calculated column with the Sort by column function.

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.