Forum Discussion
Solved
Matrix add each total for each Value in row
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
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:
audreygerred
Super User
Super UserHello! 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:
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?