Share via

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.

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

A calculation of all carbon equivalent factors and their targets shown as one figure.

Data Sources

  • Emissions Fees
  • Sustainability Goals

Employee Absences Table

Employee Absences Measures

Employee Absences

Formula

A sum of Employee Absences Quantity.

Data Sources

  • Employee Absence

Employee Absences (%)

Formula

A calculation of the Employee Absences multiplied by Active Employees and divided by Working Days to calculate the percentage of Absence Hours.

Data Sources

  • Employees
  • Employee Absence

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 the different qualifications per employee.

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 for the Employee to determine the age of the employee based on their date of birth.

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 directly in Power BI. The grouping is under 30, between 30 and 50, and then over 50. You can't change the distributions.

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 Capactity

Formula

Measures the water capacity of the facility (Responsibility Centre). The measure is based on the Month in Period when filtering.

Data Sources

  • Responsibility Centre

Sustainability Goals Table

Sustainability Goals Measures

CO2 Current Value

Formula

A sum of CO2 Emissions based on the start and dnd 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 Realised (%)

Formula

The CH4 Current Value divided by the CH4 Emissions.

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 Realised (%)

Formula

The CH4 Current Value divided by the CH4 Emissions.

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 Realised (%)

Formula

The N2O Current Value divided by the N2O Emissions.

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 Realised (%)

Formula

The Waste Current Value divided by the Waste Emissions.

Waste Current Value / 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 Realised (%)

Formula

The Water Current Value divided by the Water Emissions.

Water Current Value / 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 Realised (%)

Formula

The CO2e Current Value divided by the CO2e Emissions.

CO2e Current Value / CO2e Target

Data Sources

  • Sustainability Ledger Entries
  • Sustainability Goals

Sustainability Ledger Entries Table

Sustainability Ledger Entries Measures

CO2 Emissions

Formula

A sum of CO2 from the Sustainability Ledger Entry.

Data Sources

  • Sustainability Ledger Entry

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 the cumulative CO2 Emissions up to the latest date in the current filter. It removes all date filters, then re-applies a filter to include only dates up to and including the latest date in the selection, which gives a running balance up to the specified 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 the cumulative CH4 Emissions up to the latest date in the current filter. It removes all date filters, then re-applies a filter to include only dates up to and including the latest date in the selection, which gives a running balance up to the specified 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 the cumulative N2O Emissions up to the latest date in the current filter. It removes all date filters, then re-applies a filter to include only dates up to and including the latest date in the selection, which gives a running balance up to the specified 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 the cumulative CO2e Emissions up to the latest date in the current filter. It removes all date filters, then re-applies a filter to include only dates up to and including the latest date in the selection, which gives a running balance up to the specified 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 the cumulative Discharged Into Water up to the latest date in the current filter. It removes all date filters, then re-applies a filter to include only dates up to and including the latest date in the selection, which gives a running balance up to the specified date.

Data Sources

  • Sustainability Ledger Entry

Discharged Into Water DOD

Formula

Calculates the difference between the Discharged Into Water and the Discharged Into Water PD. It calculates the Discharge Into Water change directly in the measure as Discharged Into Water PD - Discharged Into Water

Discharge Into Water Change / 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 difference between the Discharged Into Water and Discharged Into Water PY. It calculates the Discharge Into Water change directly in the measure as Discharged Into Water PY - Discharged Into Water

Discharge Into Water Change / 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

Discharged Into Water vs Baseline (%)

Formula

The Discharged Into Water divided by the Baseline.

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 the cumulative Water Intensity up to the latest date in the current filter. It removes all date filters, then re-applies a filter to include only dates up to and including the latest date within the selection, which gives a running balance up to the specified 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 difference between the Water Intensity and the Water Intensity PD. It calculates the Water Intensity Change directly in the measure as Water Intensity PD - Water Intensity

Water Intensity Change / 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 difference between the Water Intensity and the Water Intensity PY. It calculates the Water Intensity Change directly in the measure as Water Intensity PY - Water Intensity

Water Intensity Change / 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

Water Intensity vs Baseline (%)

Formula

The Water Intensity divided by the Baseline.

Water Intensity / Baseline

Data Sources

  • Sustainability Ledger Entry

Water Available

Formula

Calculated as Facility Capacity minus Water Intensity.

Facility Capacity - Water Intensity

Data Sources

  • Sustainability Ledger Entry

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 the cumulative Water Intensity up to the latest date in the current filter. It removes all date filters, then re-applies a filter to include only dates up to and including the latest date within the selection, which gives a running balance up to the specified 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 difference between the Waste Intensity and the Waste Intensity PD. It calculates the Waste Intensity change directly in the measure as Waste Intensity PD - Waste Intensity

Waste Intensity Change / 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 difference between the Waste Intensity and the Waste Intensity PY. It calculates the Waste Intensity change directly in the measure as Waste Intensity PY - Waste Intensity

Waste Intensity Change / 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

Waste Intensity vs Baseline (%)

Formula

The Waste Intensity divided by the Baseline.

Waste Intensity / Baseline

Data Sources

  • Sustainability Ledger Entry

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