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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Not applicable

I need to Sum up a measure

I have a measure I created to get me a single value for each date. The code below allows me to take a value once since there are usually 3 records with the same MtdActual(this is because there are 3 shifts). 


My issue comes in the matrix visual that I am using this measure in. It works great for the subtotal of each product but the grand total is not calculated correctly  (Shown in the image at the bottom)


What I need to do now is get a sum of the measure but IM not sure how to do it


Heres My Measure that I would Like to Sum:

MaxMTDMaterialUnits =
As you see below my Grand total for the MTD Units is incorrect, but all my subtotals are good.
Plan vs Actual.jpg



Community Support
Community Support

Hi @Anonymous ,

You can refer the content in the following links to deal with the incorrect total values problem.

Obtaining accurate totals in DAX

DAX – Subtotals and Grand Totals That Add Up “Correctly”

Dax for Power BI: Fixing Incorrect Measure Totals

Why Your Total Is Incorrect In Power BI - The Key DAX Concept To Understand

Best Regards


Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Champion
Community Champion




Totals for MaxMTDMaterialUnits = 
SUMX( table [Material], [MaxMTDMaterialUnits])

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.


Fabric certifications survey

Certification feedback opportunity for the community.