Filter Based on modified Measure

[collmomo]

Hello, I have this Measure

Sales CY = CALCULATE(-SUM(Actual[Amount]),FILTER(Years,Years[YearID]=[Current Year]))
Current Year = VALUES(Years[YearID])

IIt works. However, if I try to modify the measure such as

Sales LY = CALCULATE(-SUM(Actual[Amount]),FILTER(Years,Years[YearID]=[Last Year]))
Last Year = [Current Year] - 1

Returns a blank value, any idea why ?

[v-sihou-msft · Accepted solution]

@collmomo

In this scenario, you need to add ALL() to ignore the current row context slicing.

Last Year Amount = var currentyear =MAX(Table7[Year])
return
CALCULATE(SUM(Table7[Amount]),FILTER(ALL(Table7),Table7[Year]=currentyear-1))

Regards,