Column totals for matrix with specific layout

Hi, I have a matrix with no stepped layout, two row fields (part of a hierarchy), no column fields and multiple value fields. So basically, except for the two row headers, all the table columns are...

Need Help

Tips and Tricks

v-alq-msft

6 years ago

Hi, fpennisi17

Based on your description, I created data to reproduce your scenario.

Table:

You may create measures as below.

Measure1 = 
IF(
    ISINSCOPE('Table'[Field]),
    SUM('Table'[Value1]),
    BLANK()
)
Measure2 = 
IF(
    ISINSCOPE('Table'[Field]),
    SUM('Table'[Value2]),
    IF(
        ISFILTERED('Table'[Level]),
        BLANK(),
        SUM('Table'[Value2])
    )
)
Measure3 = 
IF(
    ISINSCOPE('Table'[Field]),
    SUM('Table'[Value3]),
    BLANK()
)
Measure4 = 
IF(
    ISINSCOPE('Table'[Field]),
    SUM('Table'[Value4]),
    IF(
        ISFILTERED('Table'[Level]),
        BLANK(),
        SUM('Table'[Value4])
    )
)
Measure5 = 
IF(
    ISINSCOPE('Table'[Field]),
    SUM('Table'[Value5]),
    IF(
        ISFILTERED('Table'[Level]),
        BLANK(),
        SUM('Table'[Value5])
    )
)

Then you need to make the matrix selected, go to 'Visualizations' ribbon, click 'Format'=>'SubTotals', set 'Row subtotals' on.