subtotal matrix

[RosannaBALE]

hello everybody

i need a help

i want the subtotal for the following column called (capacità totale teorica), the subtotal is not correct

the formula i used to calcolate the measure was

[v-kelly-msft]

Hi @RosannaBALE ,

Create a new measure as below:

_capacita totale teorica=SUMX(VALUES('Capacita'[c.Calzaturificio]),[capacita totale teorica])

If the above doesnt work,would you pls upload your .pbix file to onedrive business and share the link with us?

Remember to remove the confidential information.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[ibarrau]

Hi. It looks like you should use the same column in the SUMMARIZE as the Rows in the Matrix. It seems to be different column. In order to correct the total try summarizing by the same column of the matrix.

Hope this helps,