Limit range of measure to a specific year

[Lobo1908]

Hi, 

I'm using the following measure to calculate the annual average for a data set. 

Average =

CALCULATE(AVERAGEX(VALUES('Calendar_lookup'[Date].[Year]),[1.2 % of components]), ALLEXCEPT('Calendar_lookup','Calendar_lookup'[Year]))

My data covers the whole 2022 year and yet to date 2023. 

Could someone please help me adjust this measure to only catch the avarage for 2022. 

[Ahmedx]

or

or
Average =
VAR _t1 = YEAR(TODAY())-1
RETURN
CALCULATE(AVERAGEX(VALUES('Calendar_lookup'[Date].[Year]),[1.2 % of components]), ALLEXCEPT('Calendar_lookup','Calendar_lookup'[Year]), CALCULATETABLE('Calendar', 'Calendar_lookup'[Year]=_t1))

[Ahmedx · Accepted solution]

Average =

VAR _t1 = YEAR(TODAY())-1

RETURN

CALCULATE(AVERAGEX(VALUES('Calendar_lookup'[Date].[Year]),[1.2 % of components]), ALLEXCEPT('Calendar_lookup','Calendar_lookup'[Year]),'Calendar_lookup'[Year]=_t1)

[Lobo1908]

@Ahmedx This one works perfect, thanks very much 

[Ahmedx]

or

Measure =
VAR _t1 = YEAR(TODAY())-1

RETURN
CALCULATE(AVERAGEX(VALUES('Calendar_lookup'[Date].[Year]),[1.2 % of components]), 'Calendar_lookup'[Year]=_t1)

[Lobo1908]

hi @Ahmedx 

The problem with your solution is that it eliminates the ALLEXEPT statement, I need to show the average as a straight line on the Line a clustern column chart. Whitout this statment it calculate trhe avarge for every month 

[Ahmedx]

CALCULATE(AVERAGEX(VALUES('Calendar_lookup'[Date].[Year]),[1.2 % of components]), 'Calendar_lookup'[Year]=2022)