Comparison of years average with baseline

[Thorgal45]

Hello,

I'm a Power BI beginner and need help for a report I'm trying to build.

I have a dataset with multiple years (2019-2022), manufacturing plants and CO2 emissions.

I'd like to show in a table for each year the CO2 emissions average variance compared to the baseline (2019 Co2 emissions average).

I tried some formulas but got the following result:

Formulas I used:

Baseline = CALCULATE(AVERAGEX(FILTER(Sheet1,Sheet1[Month - Year].[Year]=2019),Sheet1[kgCO2e per Earned Hour (kgCO2e/EH)]))

Current = CALCULATE(AVERAGE(Sheet1[kgCO2e per Earned Hour (kgCO2e/EH)]))

Variance = [Current]-[Baseline]

Dataset from Excel looks like that for each plant:

I'd like to have sometging like this instead:

Thank you for your help!

[Thorgal45]

It works and that's exactly what I need.

Thanks ryan_mayu!

[ryan_mayu]

you are welcome

[ryan_mayu · Accepted solution]

@Thorgal45 

is this what you want?

Measure = CALCULATE(AVERAGE('Table'[value]),'Table'[year]=2019)