Total is less than the actual sum

[Anonymous]

Hi all!

My ultimate goal is to make a card showing a MTD average. I made a formula but it shows a value that is too low. The formula works well in countless other reports. 

Yield MP Recycling % MTD Avg = if ( EOMONTH(max('Date'[Date]),0)=EOMONTH(today(),0),
(   TOTALMTD([Yield MP Recycling %],DATEADD(DATEADD('Date'[Date],0,Month),-1,Day))/day(today()-1)   ),

(   TOTALMTD([Yield MP Recycling %],DATEADD(DATEADD('Date'[Date],0,Month),0,Day))/ day(EOMONTH(max('Date'[Date]),0))   
))

I digged deeper and found that the problem came from "Yield MP Recycling %". When I use this measure in a table and I use a month filter I can clearly see that the total is lower than the addition of the indiviual cells. When I use a card this is the total that the card is pulling which leads to the mistake.

Yield MP Recycling % = ([Actual Produced Quantity in Weight for Dry Cleaned]+[Actual Produced Quantity Input_Output for MobilzaunfussAnlage 1]+[Actual Produced Quantity in Weight for Washing 1])/([Actual Raw Material Qty In KG for Shredder])

How can I correct this problem?

I read @Greg_Deckler  thread on the topic but I believe that this is a different issue.

Thank you very much for the help!

Warm regards,

Alain

[v-danhe-msft]

Hi @Anonymous ,

Could you please offer a sample data to have a test if possible?

Regards,

Daniel He