YTD for last 3 months based on selected month in slicer not working

[Sagejah9]

Hi, I am building a report to show last 3 months of data grouped by Month to Date and Year to date. I created a measure to Calculate the year to date amount and used the datesinperiod function to get the last 3 months. However the Ytd is not showing correctly. For instance when I select a month to show the last 3 months from, Its not calculating the YTD from January but from the earliest of the last 3 months from the month selected. 

[FarhanAhmed]

Can you please share the DAX code that you are writing to calculate your YTD ?

Also if possible if you can share the columns/measures that  you are using while creating the Matrix/Visual

[Sagejah9]

Amount_YTD= TOTALYTD(SUM(IncomeStatement[Value]),IncomeStatement[EndofMonth],"Dec/31")

[FarhanAhmed · Accepted solution]

Try Use following to calculate YTD and see if this works for you

Amount_YTD = 

CALCULATE(SUM(IncomeStatement[Value]),DATESYTD(IncomeStatement[EndofMonth]),ALL(IncomeStatement))

[Sagejah9]

It's an improvement but  it returns duplicates of the first row. The All function is causing it. 

[Sagejah9]

I figured out what the problem was. The all was applied to the wrong table. Thanks @FarhanAhmed