get wrong total in table with measure

[AleVogel]

HI,

I have two tables, one has week number and initial forecast, second table has week number and actual sales, I want combine with a measure "Actual Forecast" where measure take "actual sale" for past weeks and "first forecast" for future weeks I do the next measure

ACTUAL FORECAST =

VAR lastWeekActualSale = MAX('ActualSales'[WEEK])

VAR lastWeekForecast = MAX('FirstForecast'[WEEK]

RETURN

IF(lastWeekForecast > lastWeekActualSale ,SUM('FirstForecast'[firstForecast]),SUM(ActualSales]))

But I have an error in Total of Actual Forecast, should be 520.040.000 

How can I fix it?

Thanxs a Lot

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your datamodel looks like, but please try to write one more measure something like below and put it into your table visualization.

Actual Forecast totalfix: =
SUMX ( DISTINCT ( 'CalendarTable'[WEEK] ), [ACTUAL FORECAST] )