Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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
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!
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,
Happy to help!
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!