Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

subtotal matrix

 

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

 

 

 

 

 

Need Help

2 Replies

  • ibarrau's avatar
    ibarrau
    Super User
    5 years ago

    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,

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    5 years ago

    Hi Anonymous ,

     

    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!