Matrix with more than 1 filter

Hi ggmm17 ,

Do you mean that there are 12 legend types P1-P12 and you want to add other measures, then the columns will expand based on measures? If yes, I could reporduce your issue. 

I think you want the result P1-P12 + Measures in same levels instead of show hierarchy levels.

I suggest you to create a new Legend type table for matrix columns fields. In my sample it looks like as below.

DimLegend = 
DATATABLE(
    "Legend",STRING,
    "Order",INTEGER,
    {
        {"P1","1"},
        {"P2","2"},
        {"P3","3"},
        {"Meausre1","4"},
        {"Measure2","5"}
    }
)

Measure:

CombineMeasure = 
CombineMeasure =
IF (
    MAX ( DimLegend[Order] ) IN { 1, 2, 3 },
    [Measure for P1-P12],
    SWITCH ( MAX ( DimLegend[Order] ), 4, [Measure], 5, [Measure 2] )
)

Result is as below.

Best Regards,
Rico Zhou

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