Employee Training Status

Hey PRock ,

I created a little pbix file that you can find here:

I followed the principles of dimensional modeling and created a star schema: Simple Model - Training.pbix

I recommend reading this article about dimensional modeling and the importance of start schemas for Power BI: https://learn.microsoft.com/en-us/power-bi/guidance/star-schema?WT.mc_id=DP-MVP-5003068

I created two measures "" and "".

The first one is counting how many trainings an Emp ID has completed:

completed Trainings = COUNTROWS( 'Completed Trainings' ) 

and the second measure counts the number of trainings an Emp ID has still to complete based on the number of rows in the table "Required Trainings":

open Trainings = 
var currentEmp = SELECTEDVALUE( 'Employees'[Emp ID] )
var completedTrainings = CALCULATE( [completed Trainings] , 'Completed Trainings'[Emp ID] = currentEmp )
return

COUNTROWS( 'Required Trainings' ) - completedTrainings

The model and the measures allow to create a simple visual like the one below:

Hopefully, this helps to tackle your challenge.

Regards,

Tom