Calculate the sum of results of a measure / No forecast for a month without sales

[Fistachpl]

I have a measure that calculates for each month:
real sales (if I have data) or a forecast.

Now I would like to calculate the sum of all already sold items (this year) plus the forecast for the remaining of the current year. I get an incorrect result. How can I fix this? MEASURE: Prognozowana sprzedaż

here is the file:

Test DAX.pbix 

What am I doing wrong? 
Thank You in advance.

[some_bih]

Hi @Fistachpl I am glad you resolved it. Other solutions depend on calculation logic / inputs and requirements.

[some_bih]

Hi @Fistachpl in Tabela1 there are only data up to 20.02.2024, so the question is how to figure out what periods are current vs future / forecast if there is no data?

[Fistachpl]

Hello,

Sales should be until the month previous to the current one. E.g. if there is no sales data fo april and we already have may then for April should be 0, from may till the end of the year should be forecast.

I managed to calculate this anyway (was stuck for 2 days with it) but I would like to see other solutions 🙂