Row subtotal in a matrix

Question

Hi,&nbsp;is there a way to get the percent of row subtotals in a matrix? I'd like to obtain the row in red in the following print screen:Ex:&nbsp;&nbsp;CDColumn subtotal% of grand totalA27953%B35847%Row subtotal51217100%% of grand total29%71%100%&nbsp;&nbsp;Thanks in advance

v-easonf-msft · Accepted Answer

Hi,&nbsp;Anonymous&nbsp;
If C and D are column names in a table, you can try adding a new table as follows and put the new fields 'Row' to the rows of martix.

Then you can add custom mesures to display the values in Matrix.
For example:
C = 
VAR _total =
    CALCULATE ( SUM ( 'Table'[C] ), ALLSELECTED ( 'Table' ) )
        + CALCULATE ( SUM ( 'Table'[D] ), ALLSELECTED ( 'Table' ) )
VAR _rowsubtotal =
    CALCULATE ( SUM ( 'Table'[C] ), ALLSELECTED ( 'Table' ) )
VAR _percent =
    FORMAT ( _rowsubtotal / _total, "percent" )
RETURN
    SWITCH (
        SELECTEDVALUE ( 'Row Table'[Row] ),
        "Row subtotal", FORMAT ( CALCULATE ( SUM ( 'Table'[C] ), ALLSELECTED( 'Table' )), "General Number" ),
        "% of grand total", _percent,
        FORMAT ( SUM ( 'Table'[C] ), "General Number" )
    )

&nbsp;
Best Regards,Community Support Team _ Eason

Forum Discussion

Row subtotal in a matrix

2 Replies

Related content

Customize subtotal in matrix

Row subtotals blank

Matrix subtotal

Matrix Row Conditional Formatting

how to off row subtotal for only one value in matrix

	C	D	Column subtotal	% of grand total
A	2	7	9	53%
B	3	5	8	47%
Row subtotal	5	12	17	100%
% of grand total	29%	71%	100%