Expande / Collapse Columns in Matrix from multiple tables

Hi Joshuaa,

I had a similar requirement and i did the following to fulfil it 

wecan create a calculated table with list of measures and group them  =
DATATABLE (
"Category", STRING,
"Metric", STRING,
"SO", INTEGER,
{
{ "Open Orders", "#Open Orders", 1 },
{ "Open Orders", "Closed Orders", 2},
{ "Forecast", "Forecast next 3months", 3 },
{"Forecast", "Forecast next 6months", 4 },
{ "Forecast", "Forecast next 12months", 5 },
{ "Execution Time", "Time 1", 6 },
{ "Execution Time", "Time 2", 7 }
}
)

And use a measure to switch based on selected value 
SWITCH(SELECTEDVALUE('Metrics'[SO])
,1, [Measure 1]
,2, [Measure 2]
,3, [Measure 3]
,4, [Measure 4]
,5, [Measure 5]
,6, [Measure 6]
,7, [Measure 7]
)
And you can use this measure and category / metrics in your matrix table. You can use a (category)filter to hide/unhide certain category in the matrix table
Hope this helps