Power BI sustainability app KPIs and measures

APPLIES TO: Business Central 2025 release wave 1 and later.

This article provides a list of the key performance indicators (KPIs) that are included in the semantic model for the Power BI Sustainability report. Explore the list of KPIs to learn more about how they can help you achieve your business goals.

Each KPI is described, including how they're calculated and what data the calculations use.

The measures use imported data from the latest semantic model refresh. If the date filters in Power BI Reports Setup limit the loaded data, include the goal and baseline periods needed for your comparisons.

Percentage measures that divide by zero or a blank value return a blank result.

Emission fees table

Emissions Fees Measures

CH4 carbon equivalent

Formula

A sum of the Carbon Equivalent Factor where the Emission Type is CH4.

Data Sources

  • Emissions Fees

CO2 carbon equivalent

Formula

A sum of the Carbon Equivalent Factor where the Emission Type is CO2.

Data Sources

  • Emissions Fees

N2O carbon equivalent

Formula

A sum of the Carbon Equivalent Factor where the Emission Type is N2O.

Data Sources

  • Emissions Fees

CO2e target

Formula

Converts the CO2, CH4, and N2O targets to CO2 equivalents and adds them together.

(CO2 Target * CO2 Carbon Equivalent) + (CH4 Target * CH4 Carbon Equivalent) + (N2O Target * N2O Carbon Equivalent)

Data Sources

  • Emissions Fees
  • Sustainability Goals

Employee absences table

Employee Absences Measures

Employee absences

Formula

A sum of Quantity (Base) from Employee Absence.

Data Sources

  • Employee Absence

Employee absences (%)

Formula

The semantic model names this measure Absence Hours (%). It divides absence quantities for active employees by the number of active employees multiplied by the number of working days in the selected period.

Employee Absences for Active Employees / (Active Employees * Working Days)

The numerator uses absence quantities in base units. The denominator counts employee working days, not working hours.

The Date table filters the working-day count but isn't related to Employee Absences. A report date filter doesn't restrict the absence records included in the numerator.

Data Sources

  • Employees
  • Employee Absence
  • Working Days
  • Date

Employee ledger entries table

Employee Ledger Entries Measures

Employee amount

Formula

Sum of the Amount field from Employee Ledger Entries.

Data Sources

  • Employee Ledger Entries

Employee qualifications table

Employee Qualifications Measures

Employee qualifications

Formula

A count of employee qualification records in the current filter context. It isn't a distinct count of qualification codes.

Data Sources

  • Employee Qualifications

Employee table

Employee Measures

Active employees

Formula

A filter on the No. of Employees where the Status of the Employee is Active.

Data Sources

  • Employee

Age

Formula

A calculated column that determines an employee's age from their date of birth and the date of the semantic model refresh.

Data Sources

  • Employee

Age distribution

Formula

A calculated column to group employees into one of three different age distributions.

Note

The age distribution is defined in the semantic model. The bundled calculation groups ages under 30 as Under 30, ages 30 through 49 as 30 - 50, and ages over 50 as Over 50. The current calculation leaves age 50 ungrouped.

Data Sources

  • Employee

Female employees (%)

Formula

The No. of Female Employees divided by the No. of Employees.

No. of Female Employees / No. of Employees

Data Sources

  • Employee

Male employees (%)

Formula

The No. of Male Employees divided by the No. of Employees.

No. of Male Employees / No. of Employees

Data Sources

  • Employee

No. of employees

Formula

A count of Employees.

Data Sources

  • Employee

No. of female employees

Formula

A filter on the No. of Employees where the Employee Gender is Female.

Data Sources

  • Employee

No. of male employees

Formula

A filter on the No. of Employees where the Employee Gender is Male.

Data Sources

  • Employee

No. of other employees

Formula

A filter on the No. of Employees where the Employee Gender is not Male or Female.

Data Sources

  • Employee

Other employees (%)

Formula

The No. of Other Employees divided by the No. of Employees.

No. of Other Employees / No. of Employees

Data Sources

  • Employee

Responsibility centre table

Responsibility Centre Measures

Facility capacity

Formula

Multiplies the sum of the responsibility centers' Water Capacity Quantity(Month) values by the number of months from the earliest to the latest selected date, inclusive. A partial month counts as a month.

Data Sources

  • Responsibility Centre
  • Date

Sustainability goals table

Sustainability Goals Measures

Current values for CO2, CH4, N2O, CO2e, water, and waste ignore filters on the Date table. For each selected scorecard, they use the earliest goal start date and latest goal end date, then add the scorecard totals. The water and waste realized percentages use the selected period's intensity measures instead of these current-value measures.

CO2 current value

Formula

A sum of CO2 Emissions based on the start and end date from the selected scorecards.

Data Sources

  • Sustainability Ledger Entries
  • Sustainability Goals

CO2 target

Formula

Sum of the Target Value for CO2.

Data Sources

  • Sustainability Goals

CO2 realized (%)

Formula

The CO2 Current Value divided by the CO2 Target.

CO2 Current Value / CO2 Target

Data Sources

  • Sustainability Ledger Entries
  • Sustainability Goals

CH4 current value

Formula

A sum of CH4 Emissions based on the start and end date from the selected scorecards.

Data Sources

  • Sustainability Ledger Entries
  • Sustainability Goals

CH4 target

Formula

Sum of Target Value for CH4.

Data Sources

  • Sustainability Goals

CH4 realized (%)

Formula

The CH4 Current Value divided by the CH4 Target.

CH4 Current Value / CH4 Target

Data Sources

  • Sustainability Ledger Entries
  • Sustainability Goals

N2O current value

Formula

A sum of N2O Emissions based on the start and end date from the selected scorecards.

Data Sources

  • Sustainability Ledger Entries
  • Sustainability Goals

N2O target

Formula

A sum of Target Value for N2O from the Sustainability Goals.

Data Sources

  • Sustainability Goals

N2O realized (%)

Formula

The N2O Current Value divided by the N2O Target.

N2O Current Value / N2O Target

Data Sources

  • Sustainability Ledger Entries
  • Sustainability Goals

Waste current value

Formula

A sum of Waste Intensity based on the start and end date from the selected scorecards.

Data Sources

  • Sustainability Ledger Entries
  • Sustainability Goals

Waste target

Formula

A sum of Target Value for Waste.

Data Sources

  • Sustainability Goals

Waste realized (%)

Formula

The Waste Intensity in the current filter context divided by the Waste Target.

Waste Intensity / Waste Target

Data Sources

  • Sustainability Ledger Entries
  • Sustainability Goals

Water current value

Formula

A sum of Water Intensity based on the start and end date from the selected scorecards.

Data Sources

  • Sustainability Ledger Entries
  • Sustainability Goals

Water target

Formula

A sum of Target Value for Water.

Data Sources

  • Sustainability Goals

Water realized (%)

Formula

The Water Intensity in the current filter context divided by the Water Target.

Water Intensity / Water Target

Data Sources

  • Sustainability Ledger Entries
  • Sustainability Goals

CO2e current value

Formula

A sum of CO2e Emissions based on the start and end date from the selected scorecards.

Data Sources

  • Sustainability Ledger Entries
  • Sustainability Goals

CO2e realized (%)

Formula

The CO2e Current Value divided by the CO2e Target.

CO2e Current Value / CO2e Target

Data Sources

  • Sustainability Ledger Entries
  • Sustainability Goals
  • Emissions Fees

Sustainability ledger entries table

Sustainability Ledger Entries Measures

Baseline measures ignore filters on the Date table and use the baseline dates from the selected sustainability goals. The CO2, CH4, N2O, and CO2e baselines calculate a total for each selected scorecard and add those totals. Water, waste, and discharged-water baselines use one period from the earliest selected baseline start date to the latest selected baseline end date.

The semantic model names the water and waste baseline measures Water Baseline and Waste Baseline. Their comparison measures are Water vs Baseline (%) and Waste vs Baseline (%).

CO2 emissions

Formula

A sum of CO2 from the Sustainability Ledger Entry.

Data Sources

  • Sustainability Ledger Entry
  • Sustainability Goals

CO2 emissions balance

Formula

Calculates the total CO2 Emissions across all dates and ignores filters on the Date table. By removing date-based filtering, this measure provides the full value from the start to the end of the dataset.

Data Sources

  • Sustainability Ledger Entry

CO2 emissions balance at date

Formula

Calculates cumulative CO2 Emissions up to the latest date in the current selection. The calculation filters the Date column to dates up to and including that date.

Data Sources

  • Sustainability Ledger Entry

CO2 baseline

Formula

A sum of CO2 Emissions based on the Baseline Start and End Date from the selected scorecards to determine a Baseline value.

Data Sources

  • Sustainability Ledger Entry
  • Sustainability Goals

CO2 vs baseline (%)

Formula

The CO2 Current Value divided by the CO2 Baseline.

CO2 Current Value / CO2 Baseline

Data Sources

  • Sustainability Ledger Entry
  • Sustainability Goals

CH4 emissions

Formula

A sum of CH4 from the Sustainability Ledger Entry.

Data Sources

  • Sustainability Ledger Entry

CH4 emissions balance at date

Formula

Calculates cumulative CH4 Emissions up to the latest date in the current selection. The calculation filters the Date column to dates up to and including that date.

Data Sources

  • Sustainability Ledger Entry

CH4 emissions balance

Formula

Calculates the total CH4 Emissions across all dates, and ignore filters on the Date table. By removing date-based filtering, this measure provides the full value from the start to the end of the dataset.

Data Sources

  • Sustainability Ledger Entry

CH4 baseline

Formula

A sum of CH4 Emissions based on the Baseline Start and End Date from the selected scorecards to determine a Baseline value.

Data Sources

  • Sustainability Ledger Entry
  • Sustainability Goals

CH4 vs baseline (%)

Formula

The CH4 Current Value divided by the CH4 Baseline.

CH4 Current Value / CH4 Baseline

Data Sources

  • Sustainability Ledger Entry
  • Sustainability Goals

N2O emissions

Formula

A sum of N2O from the Sustainability Ledger Entry.

Data Sources

  • Sustainability Ledger Entry

N2O emissions balance at date

Formula

Calculates cumulative N2O Emissions up to the latest date in the current selection. The calculation filters the Date column to dates up to and including that date.

Data Sources

  • Sustainability Ledger Entry

N2O emissions balance

Formula

Calculates the total N2O Emissions across all dates, and ignore filters on the Date table. By removing date-based filtering, this measure provides the full value from the start to the end of the dataset.

Data Sources

  • Sustainability Ledger Entry

N2O baseline

Formula

A sum of N2O Emissions based on the Baseline Start and End Date from the selected scorecards to determine a Baseline value.

Data Sources

  • Sustainability Ledger Entry
  • Sustainability Goals

N2O vs baseline (%)

Formula

The N2O Current Value divided by the N2O Baseline

N2O Current Value / N2O Baseline

Data Sources

  • Sustainability Ledger Entry
  • Sustainability Goals

CO2e emissions

Formula

A sum of CO2e from the Sustainability Ledger Entry.

Data Sources

  • Sustainability Ledger Entry

CO2e emissions (excl credits)

Formula

Uses the existing CO2e Emissions and filters to where the document type isn't GHG Credit.

Data Sources

  • Sustainability Ledger Entry

CO2e emissions balance at date

Formula

Calculates cumulative CO2e Emissions up to the latest date in the current selection. The calculation filters the Date column to dates up to and including that date.

Data Sources

  • Sustainability Ledger Entry

CO2e emissions balance

Formula

Calculates the total CO2e Emissions across all dates, and ignores filters on the Date table. By removing date-based filtering, this measure provides the full value from the start to the end of the dataset.

Data Sources

  • Sustainability Ledger Entry

CO2e baseline

Formula

A sum of CO2e Emissions based on the Baseline Start and End Date from the selected scorecards to determine a Baseline value.

Data Sources

  • Sustainability Ledger Entry
  • Sustainability Goals

CO2e vs baseline (%)

Formula

The CO2e Current Value divided by the CO2e Baseline.

CO2e Current Value / CO2e Baseline

Data Sources

  • Sustainability Ledger Entry
  • Sustainability Goals

Discharged into water

Formula

A sum of Discharged Into Water from the Sustainability Ledger Entry.

Data Sources

  • Sustainability Ledger Entry

Discharged into water balance

Formula

Calculates the total Discharged Into Water value across all dates, and ignores filters on the Date table. By removing date-based filtering, this measure provides the full value from the start to the end of the dataset.

Data Sources

  • Sustainability Ledger Entry

Discharged into water balance at date

Formula

Calculates cumulative Discharged Into Water up to the latest date in the current selection. The calculation filters the Date column to dates up to and including that date.

Data Sources

  • Sustainability Ledger Entry

Discharged into water DOD

Formula

Calculates the percentage change from the prior day to the current period. A positive value indicates an increase.

(Discharged Into Water - Discharged Into Water PD) / Discharged Into Water PD

Data Sources

  • Sustainability Ledger Entry

Discharged into water PD

Formula

Calculates the Discharged Into Water for the prior day.

Data Sources

  • Sustainability Ledger Entry

Discharged into water PY

Formula

Calculates the Discharged Into Water for the prior year.

Data Sources

  • Sustainability Ledger Entry

Discharged into water YOY

Formula

Calculates the percentage change from the prior year to the current period. A positive value indicates an increase.

(Discharged Into Water - Discharged Into Water PY) / Discharged Into Water PY

Data Sources

  • Sustainability Ledger Entry

Discharged into water baseline

Formula

A sum of Discharged Into Water based on the Baseline Start and End Date from the selected scorecards to determine a Baseline value.

Data Sources

  • Sustainability Ledger Entry
  • Sustainability Goals

Discharged into water vs baseline (%)

Formula

The Discharged Into Water divided by the Discharged Into Water Baseline.

Discharged Into Water / Discharged Into Water Baseline

Data Sources

  • Sustainability Ledger Entry

Water intensity

Formula

Sum of Water Intensity from the Sustainability Ledger Entry.

Data Sources

  • Sustainability Ledger Entry

Water intensity balance at date

Formula

Calculates cumulative Water Intensity up to the latest date in the current selection. The calculation filters the Date column to dates up to and including that date.

Data Sources

  • Sustainability Ledger Entry

Water intensity balance

Formula

Calculates the total Water Intensity across all dates, and ignores filters on the Date table. By removing date-based filtering, this measure provides the full value from the start to the end of the dataset.

Data Sources

  • Sustainability Ledger Entry

Water intensity DOD

Formula

Calculates the percentage change from the prior day to the current period. A positive value indicates an increase.

(Water Intensity - Water Intensity PD) / Water Intensity PD

Data Sources

  • Sustainability Ledger Entry

Water intensity PD

Formula

Calculates the Water Intensity for the prior day.

Data Sources

  • Sustainability Ledger Entry

Water intensity PY

Formula

Calculates the Water Intensity for the prior year.

Data Sources

  • Sustainability Ledger Entry

Water intensity YOY

Formula

Calculates the percentage change from the prior year to the current period. A positive value indicates an increase.

(Water Intensity - Water Intensity PY) / Water Intensity PY

Data Sources

  • Sustainability Ledger Entry

Water intensity baseline

Formula

A sum of Water Intensity based on the Baseline Start and End Date from the selected scorecards to determine a Baseline value.

Data Sources

  • Sustainability Ledger Entry
  • Sustainability Goals

Water intensity vs baseline (%)

Formula

The Water Intensity divided by the Baseline.

Water Intensity / Baseline

Data Sources

  • Sustainability Ledger Entry
  • Sustainability Goals

Water available

Formula

Calculated as Facility Capacity minus Water Intensity.

Facility Capacity - Water Intensity

Data Sources

  • Sustainability Ledger Entry
  • Responsibility Centre
  • Date

Waste intensity

Formula

A sum of Waste Intensity from the Sustainability Ledger Entry.

Data Sources

  • Sustainability Ledger Entry

Waste intensity balance at date

Formula

Calculates cumulative Waste Intensity up to the latest date in the current selection. The calculation filters the Date column to dates up to and including that date.

Data Sources

  • Sustainability Ledger Entry

Waste intensity balance

Formula

Calculates the total Waste Intensity across all dates, and ignores filters on the Date table. By removing date-based filtering, this measure provides the full value from the start to the end of the dataset.

Data Sources

  • Sustainability Ledger Entry

Waste intensity DOD

Formula

Calculates the percentage change from the prior day to the current period. A positive value indicates an increase.

(Waste Intensity - Waste Intensity PD) / Waste Intensity PD

Data Sources

  • Sustainability Ledger Entry

Waste intensity PD

Formula

Calculates the Waste Intensity for the prior day.

Data Sources

  • Sustainability Ledger Entry

Waste intensity PY

Formula

Calculates the Waste Intensity for the prior year.

Data Sources

  • Sustainability Ledger Entry

Waste intensity YOY

Formula

Calculates the percentage change from the prior year to the current period. A positive value indicates an increase.

(Waste Intensity - Waste Intensity PY) / Waste Intensity PY

Data Sources

  • Sustainability Ledger Entry

Waste intensity baseline

Formula

A sum of Waste Intensity based on the Baseline Start and End Date from the selected scorecards to determine a Baseline value.

Data Sources

  • Sustainability Ledger Entry
  • Sustainability Goals

Waste intensity vs baseline (%)

Formula

The Waste Intensity divided by the Baseline.

Waste Intensity / Baseline

Data Sources

  • Sustainability Ledger Entry
  • Sustainability Goals

Purchased carbon credits

Formula

Uses the existing CO2e Emissions and filters to where the document type is GHG Credit.

Data Sources

  • Sustainability Ledger Entry

Sustainability Overview (Power BI Report)
Sustainability management overview
Sustainability reports and analytics in Business Central

Find free e-learning modules for Business Central here