Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

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

RosannaBALE_1-1607682683145.png

 

 

 

 

RosannaBALE_0-1607682540033.png

 

2 REPLIES 2
v-kelly-msft
Community Support
Community Support

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!

ibarrau
Super User
Super User

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,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors