Using selectedvalue to determine previous year and pass to variable

[adam_macs]

Hi, below measure is essentially trying to determine the sales for the year before the one the user has selected.

i am using VAR selected_assessmentYear  to determine the year that the user has selected in the slicer and then subtracting 1 to determine the previous year. 

When i test VAR selected_assessmentYear in a separate measure, it works fine and successfully shows the previous year. However when i pass it to the Finance_Sales[AcademicYear] section it doesn't seem to work and reverts to the year they user has selected instead. 

Order Value (Previous AY) = 
VAR selected_assessmentYear = SELECTEDVALUE( Finance_Sales[AcademicYear].[Year],0)-1
RETURN
CALCULATE(
SUM(Finance_Sales[NetValueBasedOnCommitment]),
YEAR(
Finance_Sales[AcademicYear] = selected_assessmentYear))

[PaulOlding]

The position of the brackets doesn't look right in this line:

YEAR(Finance_Sales[AcademicYear] = selected_assessmentYear))

Shouldn't you have a closing round bracket after [AcademicYear]?

[adam_macs]

hi @PaulOlding, nope im afraid that didnt do it. When i insert insert closing brackets around the academic year it returns null. 

[adam_macs · Accepted solution]

figured it out....below for anyone interested

AY Test Year = 
VAR previousYR = SELECTEDVALUE( Finance_Sales[AcademicYear].[Year],0)-1
RETURN
CALCULATE (
[Net_Order_Value_(commit)],
FILTER (
ALL ( Finance_Sales ),
Finance_Sales[AcademicYear].[Year] = previousYR))

[PaulOlding]

Do you have some example data you can share?