MTD with variable date

Hi,

I would like some help with the following problem. I have a table with sales per day. I would like to calculate MTD sales, however I want the result to change based on a single day time slicer. I am using TOTALMTD function, however, when selecting a single day, the result is only the sales of that specific date, instead of the MTD sum.

For example:

In the above example, when selecting 3/6 as date, the result would be 120, instead of 100+50+120.

Could you please help me with the above? Thank you in advance!