# 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
 #co2-carbon-equivalent
 #n2o-carbon-equivalent
 #co2e-target
### 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
 #employee-absences-
### 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
### 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
### 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
 #age
 #age-distribution
 #female-employees-
 #male-employees-
 #no-of-employees
 #no-of-female-employees
 #no-of-male-employees
 #no-of-other-employees
 #other-employees-
### 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
### 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
 #co2-target
 #co2-realized-
 #ch4-current-value
 #ch4-target
 #ch4-realized-
 #n2o-current-value
 #n2o-target
 #n2o-realized-
 #waste-current-value
 #waste-target
 #waste-realized-
 #water-current-value
 #water-target
 #water-realized-
 #co2e-current-value
 #co2e-realized-
### 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
 #co2-emissions-balance
 #co2-emissions-balance-at-date
 #co2-baseline
 #co2-vs-baseline-
 #ch4-emissions
 #ch4-emissions-balance-at-date
 #ch4-emissions-balance
 #ch4-baseline
 #ch4-vs-baseline-
 #n2o-emissions
 #n2o-emissions-balance
 #n2o-emissions-balance-at-date
 #n2o-baseline
 #n2o-vs-baseline-
 #co2e-emissions
 #co2e-emissions-excl-credits
 #co2e-emissions-balance
 #co2e-emissions-balance-at-date
 #co2e-baseline
 #co2e-vs-baseline-
 #discharged-into-water
 #discharged-into-water-balance
 #discharged-into-water-balance-at-date
 #discharged-into-water-dod
 #discharged-into-water-pd
 #discharged-into-water-py
 #discharged-into-water-yoy
 #discharged-into-water-baseline
 #discharged-into-water-vs-baseline-
 #water-intensity
 #water-intensity-balance
 #water-intensity-balance-at-date
 #water-intensity-dod
 #water-intensity-pd
 #water-intensity-py
 #water-intensity-yoy
 #water-intensity-baseline
 #water-intensity-vs-baseline-
 #water-available
 #waste-intensity
 #waste-intensity-balance
 #waste-intensity-balance-at-date
 #waste-intensity-dod
 #waste-intensity-pd
 #waste-intensity-py
 #waste-intensity-yoy
 #waste-intensity-baseline
 #waste-intensity-vs-baseline-
 #purchased-carbon-credits
### 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 / #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 / #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
## Related information
Sustainability Overview (Power BI Report)<sustainability-powerbi-sustainability-overview>
Sustainability management overview<finance-manage-sustainability>
Sustainability reports and analytics in Business Central<sustainability-reports>
Find free e-learning modules for Business Central here<https://learn.microsoft.com/training/dynamics365/business-central>

Copyright (c) Microsoft Corporation. CC BY 4.0, https://creativecommons.org/licenses/by/4.0/; code samples MIT. From https://learn.microsoft.com/en-us/dynamics365/business-central/sustainability-powerbi-kpis, MicrosoftDocs/dynamics365smb-docs at 46907ac (2026-11-19). Changed: includes filled in, links to this site, and for agents shortened without dropping a fact. https://jonas-paprotka.de/docs/sustainability-powerbi-kpis/
