Correct total sum of Actual and Budget

[FilipFireFlyBI]

Hi all,

I want to correctly sum actuals and budget, I have a submission datetable and a value datetable.
So for example when I choose 2021 February as submission Year/month I see all actual data for JAN and FEB 2021, and all other months are Budget.
When I select the first 6 months of 2021 (JAN to JUN) within the value datetable I see six months of data, 2 actuals and 4 budget.

I created a measure to construct this, and this perfectly works for the individual months. However the total is incorrect, this only shows the sum of budget months. 

Important: currenctly the Dim SubmissionDate table is NOT linked, you may link this to the 2 fact tables (Actuals and Budget) if you believe this is required.

See attached a PBIX file and two screenshots from this PBIX file.

Link to PBIX file: https://www.dropbox.com/s/riib62sd71vdini/Correct%20totals%2012%20month%20AC%20and%20BU.pbix?dl=0

Thanks in advance!

[PaulDBrown · Accepted solution]

@FilipFireFlyBI 

Use SUMX with your measure:

Sumx Measure AC + BU.. =
SUMX ( 'Dim ValueDates', [Measure AC + BU incorrect Total] )