Month-to-Date Measure Not Working?

Hi Anonymous,

1.The TOTALMTD evaluates the value of the expression for the month to date, in the current context.

From screenshot of my PBI table you provide, there is only one piece of data per month without any specific date, then the function ToTALMTD will calculate the data of the whole current month, so the result of measure Change MTD is also correct.

2. If you want to calculate the cumulative total of Change but not the Month -To -Date, you could create the measure below.

MTDChange =
CALCULATE (
    SUM ( breaches[change] ),
    FILTER (
        ALL ( breaches ),
        'breaches'[RETALERS] <= MAX ( 'breaches'[RETALERS] )
    )
)

You could refer to the picture of the result:

If it is not your desired result, please show your desired output.

Hope it can help you !

Best Regards,

Cherry