Nulverzuim: formule en voorbeeld.

WITH full_year AS (
  SELECT employee_id FROM employees
  WHERE hire_date <= DATE '2025-01-01'
    AND (termination_date IS NULL OR termination_date > DATE '2025-12-31')
),
sick AS (
  SELECT DISTINCT employee_id FROM absences
  WHERE start_date <= DATE '2025-12-31'
    AND COALESCE(end_date, DATE '2025-12-31') >= DATE '2025-01-01'
)
SELECT COUNT(*) AS employees_full_year,
       COUNT(*) FILTER (WHERE s.employee_id IS NULL) AS zero_absence,
       ROUND(100.0 * COUNT(*) FILTER (WHERE s.employee_id IS NULL) / NULLIF(COUNT(*), 0), 1) AS zero_absence_pct
FROM full_year f
LEFT JOIN sick s ON s.employee_id = f.employee_id;

Zero Absence % =
VAR StartDate = MIN ( 'Date'[Date] )
VAR EndDate = MAX ( 'Date'[Date] )
VAR FullPeriod = FILTER ( ALL ( Employees ), Employees[HireDate] <= StartDate && ( ISBLANK ( Employees[TerminationDate] ) || Employees[TerminationDate] > EndDate ) )
VAR NoAbsence = FILTER ( FullPeriod, ISEMPTY ( FILTER ( ALL ( Absences ), Absences[EmployeeId] = Employees[EmployeeId] && Absences[StartDate] <= EndDate && ( ISBLANK ( Absences[EndDate] ) || Absences[EndDate] >= StartDate ) ) ) )
RETURN DIVIDE ( COUNTROWS ( NoAbsence ), COUNTROWS ( FullPeriod ) )