Why does"Running Total Mesaure" calculate with the same month value of the previous year?

[sinanalmac]

Hi  All I have a very interseting problem. Please Help me 
 I created a running total  formule . it woks fine when I select All previous month. In my data  october values are not compelted yet.   Few days remanining to complete.
When I selecet  Octorber it calculated 2020 october's value too.  

Here is september's screenshots. Evertbihg is ok

here is October Screen shot. it is added previous year's octotober total 

 here is  my formula 

Running Total1 = CAlculate(SUM(Sheet2[TURNOVER]), 
FILTER(
    ALL(DateTable),
DateTable[DATE]<=MAX(DateTable[DATE])
),VALUES(DateTable[Monthnumber])


)

 You can Find my file  here  if you want to look at it  https://www.dropbox.com/s/g7hf3m43aa2ufzq/runningtotal.pbix?dl=0

I couldn't find any solution please help me

Best regards
Sinan 

[Anonymous · Accepted solution]

@sinanalmac Try this:

Running Total1 = CAlculate(SUM(Sheet2[TURNOVER]), 
FILTER(
    ALL(DateTable),
DateTable[DATE]<=MAX(DateTable[DATE])
),VALUES(DateTable[Monthnumber]),VALUES(DateTable[Year])
)