Total Row Miscalculation

Thanks for the attention to the problem from Ritaf1983.

Hi BuckedUpJJP ,

I don't have access to the link you provided, so I created simple test data:

The reason the total row is incorrect is that it adds up all the values and divides by 31, whereas there are not actually 31 days in every month. At this point we can create another measure:

Final Budget = SUMX(VALUES('dim_dates'[Month]),[Daily Budget])

Result:

Best Regards,
Zhu

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