Override Year Slicer For Previous Measure

[curtismob]

Hello, I have a matrix with monthly costs, along with the variances from month to month.  I have a slicer to select the year, but I also want to inlcude the cost for the previous December, in order to calculate the Decemeber Prior Year/January variance.  See screen shot below.

Prior December measure:

DecCostPriorYr =

VAR YearSelectedLessOne =

SELECTEDVALUE(PlanCost[Year]) - 1

VAR CostCalc =

CALCULATE(SUM(PlanCost[Cost]),

FILTER(ALL(PlanCost),

PlanCost[Month] = 12 &&

PlanCost[Year] = YearSelectedLessOne))

RETURN

CostCalc

Here is the link to the pbix.

https://drive.google.com/file/d/1V1M0Dho5P7ICGhvXTBaPPwaUNpzOs1_E/view?usp=drive_link

Thank you in advance,

@curtismob 

[Pady]

Please change replace ALL with ALLSELECTED . Hope it works.

DecCostPriorYr =

VAR YearSelectedLessOne =

SELECTEDVALUE(PlanCost[Year]) - 1

VAR CostCalc =

CALCULATE(SUM(PlanCost[Cost]),

FILTER(ALLSELECTED(PlanCost),

PlanCost[Month] = 12 &&

PlanCost[Year] = YearSelectedLessOne))

RETURN

CostCalc

[curtismob]

Thank you for the quick response.  Unfortunately, that did not work, all values are blank when using ALLSELECTED.

@curtismob 

[Pady]

Sorry, I am unable to access the Googledrive link. Could you change the permission to anyone with link can download?

[curtismob]

I'm so sorry, here is the new link.

https://drive.google.com/file/d/1V1M0Dho5P7ICGhvXTBaPPwaUNpzOs1_E/view?usp=sharing

[Pady]

Sorry, I am unable to find the  pbix file in any of the folders. Could you please send the link for the pbix file?

[curtismob]

Is this what you see when clciking the link?  Is the download icon available?

[Pady · Accepted solution]

Sorry about the previous post. The following formula works

DecCostPriorYr =

VAR YearSelectedLessOne =

SELECTEDVALUE(PlanCost[Year]) - 1

VAR CostCalc =

CALCULATE(SUM(PlanCost[Cost]),

FILTER(ALL(PlanCost[Community],PlanCost[Month],PlanCost[Year]),

PlanCost[Month] = 12 && PlanCost[Year] = YearSelectedLessOne))

RETURN

CostCalc

[curtismob]

The latest change worked, thank you for your help!!

@curtismob