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
- 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
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
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.
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.
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 management overview
Sustainability reports and analytics in Business Central