Calculating Averages over year, set filter context to year

[HB_Penguin]

Hello,

I have a table with an inventory amount and an inventory average

If I go to the month level, the average is shown for the month, but I would like to show the same yearly average for every month in the year.

So for 2020 I would like every Average Inventory value to be 787.

I appreciate any help.

Kind regards

[DataInsights]

@HB_Penguin,

Try this measure:

Average Inventory = 
CALCULATE (
    AVERAGE ( Table1[Inventory Amount] ),
    ALLEXCEPT ( Table1, Table1[CUST-ID], Table1[Jahr] )
)