MTD vs YTD

The TOTALYTD function calculates the year-to-date total, and it allows you to specify an optional end date (like "31/03"). This date parameter tells the function to compute the year-to-date total up to that specific date.

The TOTALMTD function, on the other hand, is designed to calculate the month-to-date total. Unlike TOTALYTD, it doesn't typically require or accept an end date in the same way. The issue arises because the "31/03" date string doesn't match the expected date format or handling in TOTALMTD.

To correct the issue with the TOTALMTD function, you should remove the "31/03" end date from the calculation:

Assessment Closed Cases MTD = 
CALCULATE(
    TOTALMTD(
        COUNT('Cases'[Case Number]), 
        'Cases'[Resolution Date]
    ),
    'Cases'[statecode] = "Resolved",
    'Cases'[User Team Name] = "Assessment"
)