Average per Year

[LeylaD]

Hello All, 
I have created 

AvgAmount =

AVERAGEX(ALL('Calendar'[Date].[Year]),Calculate(AVERAGEX(Values('Calendar'[Date].[Year]),[Amount])))

But the problem is that I have a year filter on the visual and this formula doest take that into concideration. 

The average is lower as if for all the years in the calendar, what shall i adjust to exclude those years?

Thank you.

[LeylaD]

that was it, thanks

[olgad · Accepted solution]

Hi there,

try changing ALL to ALLSELECTED to take the filter into account.