Forum Discussion

benlynch225's avatar
benlynch225
Frequent Visitor
3 years ago
Solved

Sorting a matrix with multiple measures in row groups

Hi all, I don't know if this is possible but I am trying to find a way to row a matrix that currently only consists of 6 measures added to the Values part of a Matrix. There are no rows or columns ad...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    Hi, benlynch225 ;

    You could enter a table such as:

    then create a measure.

    Measure = SWITCH(MAX('Table (2)'[Name]),
 "Current Plan",[Current Plan],
 "Last 2 Weeks Actuals",[Last 2 Weeks Actuals],
 "What If Scenario",[What If Scenario],
 "Prev Year Actuals",[Prev Year Actuals])

    the final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Hi, benlynch225 ;

You could enter a table such as:

then create a measure.

Measure = SWITCH(MAX('Table (2)'[Name]),
 "Current Plan",[Current Plan],
 "Last 2 Weeks Actuals",[Last 2 Weeks Actuals],
 "What If Scenario",[What If Scenario],
 "Prev Year Actuals",[Prev Year Actuals])

the final show:


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • benlynch225's avatar
    benlynch225
    Frequent Visitor
    3 years ago

    This is perfect - thank you very much!