Help with measure required - incorrect column subtotals

[Syrah5354]

Hi All, 

I am still quite new to Power BI and DAX and need some help with a measure. I have 3 tables I am using data from as well as a date table they are all connected to. 

Tables 

1. Forecast table - weekly values are added for a monthly forecast. 

Date of Forecast	Forecast Month	Sales Person	Forecast
5/7/2023	31/7/2023	John Smith	10000
12/7/2023	31/7/2023	John Smith	10500
5/7/2023	31/8/2023	John Smith	25000
12/7/2023	31/8/2023	Johh Smith	20000

2. Quotas - contains information on a sales persons quota by month

Sales Person	Month	Quota
John Smith	31/7/2023	20000
John Smith	31/8/2023	20000

3. Actuals - obtained at the end of each month for each sale made

Date of Sale	Sales Person	Amount
4/7/2023	John Smith	5000
13/7/2023	John Smith	1000
13/7/2023	John Smith	1500

By month, I would like to record the gap to the individuals quota where we use the persons actuals if available, and if not, we use the forecast.

This is an example of my current view. It is all accurate except the column subtotals for delta to quota.

The measures in this view are:

Forecast = 

var LatestDateForecast = MAX('Forecast'[Date of Forecast])

return

CALCULATE(SUM('Forecast'[Forecast]),'Forecast'[Date of Forecast] = LatestDateForecast)

Actuals = (CALCULATE(SUM('Individual GP Analysis'[Gross Profit])))

Quota = SUM(Quotas[Quota])

Delta to quota = 

 IF(ISBLANK([Actuals]), [Quota] - [Forecast], [Quota] - [Actuals])

This measure is the one I am having issues with. It appears to work for each month but the subtotal is incorrect.

Can someone please let me know what I am doing wrong.

Thanks so much!

[johnt75]

I think https://www.sqlbi.com/articles/why-power-bi-totals-might-seem-inaccurate/ will explain.