Previous Year Calculation plotting oddly on line graph

[vanessafvg]

as you can see from the line graph i have a revenue measure and previous year revenue.   What i dont understand is why doesn't the PY plot the same as the revenue.

this is the measure for the revenue

Revenue = CALCULATE(Sum(Registrations[MRR]) + sum(Sales[RevenueNettAmount])) 

this is the measure for PY

PY Revenue = CALCULATE([Revenue], SAMEPERIODLASTYEAR(ALLSELECTED('Fiscal Date'[Date])))

I would like the value to plotted on the line graph in the same way, what am i missing?  The other thing is these seem to be bring back exactly the same values

[MalS]

How does PY Revenue = CALCULATE([Revenue], SAMEPERIODLASTYEAR('Fiscal Date'[Date])) look?

[vanessafvg]

ah yes sorry my mistake, the problem with that, which i did before i changed it to this was because i have a filter on date on my dashboard as in year month it brings back 0  

[MalS]

The date filter shouldn't stop SAMEPERIODLASTYEAR from working without ALLSELECTED. Any chance there was actually 0 revenue last year in your data?

[vanessafvg]

nope 🙂    There is data for the previous year, but what is interesting is that its duplicating the current years data in the PY measure.. something is off..

[MalS]

Yeah - strange. The only other thing I would suggest is to check the date column in the SAMEPERIODLASTYEAR formula - it needs to be a proper calendar table (no missing dates, no duplicates, must cover the entire period of your data). Otherwise, without seeing the file, I am not sure what is going on.

[vanessafvg]

it comes from the dim date column in the dw so i hope its fully populated but i would think so since its in daily use in the dw.   ive obviously done something somewhere!

[vanessafvg]

from what perspective?  see first graph for how it is plotting as opposed to revenue. 

[MalS]

Not sure if you noticed, but I changed the formula slightly for PY Revenue - I was wondering if that gave results that made more sense.