Measure to show monthly total against each date row

[MarkSL]

Hi,

I need to be able to show the monthly total of Sales Amount against each individual date in a table.  So for example, if Sales Amount was 10 for each day in January, the monthly toal would be 310 and should be reported against each row:

DATE           Sales Amount        MonthlyTotal
01/01/18      10                           310
02/01/18      10                           310
03/01/18      10                           310
04/01/18      10                           310
05/01/18      10                           310

So I essentially want to ignore the filter on day but keep that of Year and Month, something along the lines of:

Sales Monthly = CALCULATE(Sales[Sales Amount], ALL('Date'[Calendar Year], 'Date'[Month]))

However this does not work.  Please see basic example at the below link:

https://www.dropbox.com/s/7o6zvymfilmp3es/Monthly%20Sales%20Query.pbix?dl=0

I am sure this should be very simple, but I my Dax is not on form today!

Thanks

Mark

I have also tried

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[MarkSL]

Perfect, thank you both for your help.

[HotChilli]

Sales Monthly = TOTALMTD(Sales[Sales Amount], ENDOFMONTH('Date'[Date]))