YTD Counts Calculation in powerpivot

[jeancake]

Hi. I wrote a measure to calculate YTD accounts opened by office.

Office is in rows and the measure is [YTD Accounts Opened= DatesYTD([Accounts Opened]). This measure is calculated correctly, but when I create a measure for Year to Date accounts opened last year I get the full year accounts opened not the comparative time period. The measure I use calculate([YTD Accounts Opened],SamePeriodLastYear('Calendar'[Date]))

What am i doing wrong?