I need to Sum up a measure

[Anonymous]

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 =

MAXX(

KEEPFILTERS(VALUES(V_PBI_Daily_Attainment[Date])),

CALCULATE((MAX(V_PBI_Daily_Attainment[MtdActual]))))

As you see below my Grand total for the MTD Units is incorrect, but all my subtotals are good.

[v-yiruan-msft]

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

Rena

[PaulDBrown]

@Anonymous 

Try: 

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