Matrix add each total for each Value in row

[Em3dream123]

Hi all,

I am trying to get the SUM of each value of rows but I have no idea on how to do it.

Example for what I have :

Example for what I wish :

Thank you for you help 

[Em3dream123]

@audreygerred How about add each total for each Value in sub column instead of row, i want adding total of "SAN_LUONG","TIEN_NUOC" below total col?

[audreygerred]

Hello! Are "SAN_LUONG","TIEN_NUOC" separate measures in your model or is it one measure that is categorized by a dimension field? 

[Em3dream123]

@audreygerred i did it but now i have new problem

as you see the bold number below is calucate by TIEN_NUOC/SAN_LUONG,
and SL_DHN is the columns to show for each row not depence by A, B columns
any idea for that problem Thanks you

[Em3dream123]

Hi @audreygerred , in that formula, 

SL = CALCULATE(

    [YourMeasure],

    'TableName'[CATEGORY_GRP] IN { "SL" }

)
What needs to be provided for [YourMeasure] 
Thanks you.

[audreygerred]

Whatever measure you have in place that gets you these values in your chart (I am assuming it is a sum of a field in your table). If you don't have this base measure yet, create that, then create the SL and TN measures that will use it.

[Em3dream123]

thanks you, that working!

[audreygerred]

Awesome! Happy I could help!

[audreygerred · Accepted solution]

Hello! Create an explicit measure for SL an TN (Basically, take whatever measure you have for the values now and create two more - one that is based on it being filtered to SL and one for TN: 

SL = CALCULATE(

    [YourMeasure],

    'TableName'[CATEGORY_GRP] IN { "SL" }

)

then,

TN = CALCULATE(

    [YourMeasure],

    'TableName'[CATEGORY_GRP] IN { "TN" }

)

Once these are ready, remove the measure you have now and add these two, then go to the formatting for the matrix, expand the values section, expand options and switch values to rows:

Here is one I did with some sample data to show how it would look:

[tornikevadach]

No entiendo, yo necesito 2 filas de total, uno para el total annual y otro para el total YTD y no consigo hacerlo en la misma tabla

Como puedo hacer para añadir el total de fila YTD que me falta?