MTD Running Total Sales

Hi all,

I have already posted regarding this problem and never really found a solution so I am going to rephrase hoping someone out there can help.

I am trying to build measures allowing to give me MTD Running Total Sales for the current fiscal year and the previous one.

To do so, I came up with the following measures:

Prev MTD Running Total Sales = 
VAR CurrentDayNumber =
    MAX(YTDInfos[CurrentDayNumber])
RETURN
    IF (
        MIN ( 'Calendar'[Date] )
            <= CALCULATE (
                MAX ( Sales[Date] );
                FILTER (
                    ALL ( Sales );
                    AND (
                        RELATED ( 'Calendar'[MonthOffset] ) = -12;
                        RELATED ( 'Calendar'[DayNumber] ) <= CurrentDayNumber
                    )
                )
            );
        CALCULATE (
            [Total Sales];
            FILTER (
                FILTER (
                    ALL ( 'Calendar' );
                    AND (
                        'Calendar'[MonthOffset] = -12;
                        'Calendar'[DayNumber] <= CurrentDayNumber
                    )
                );
                'Calendar'[Date] <= MAX ( 'Calendar'[Date] )
            )
        )
    )

MTD Running Total Sales = 
IF (
    MIN ( 'Calendar'[Date] )
        <= CALCULATE (
            MAX ( Sales[Date] );
            FILTER ( ALL ( Sales ); RELATED('Calendar'[MonthOffset]) = 0 )
        );
    CALCULATE (
        [Total Sales];
        FILTER (
            FILTER ( ALL ( 'Calendar' ); 'Calendar'[MonthOffset] = 0 );
            'Calendar'[Date] <= MAX ( 'Calendar'[Date] )
        )
    )
)

When looking at the result through a Table, including Fiscal Year, Month Number and Day Number, everything seems to work just fine:

Now, when removing the Fiscal Year and the Month Number from the table, here's what I am expecting to get:

But here's what I am getting:

This is driving me crazy as I have been stuck with this for quite some time and still cannot figure out what is wrong!!!

Any help would be greatly appreciated.

I can share a pbix file if necessary.

Thanks!