Count number of items (training) past due based on their due date per employee

[ejneyman]

I have a table with employee names and when each training course was due and when it was completed.  I would like to be able to do a couple of things:

- produce a visual of a stacked chart that shows % complete and % remain of training for each person and then another by month

- produce a visual of a KPI that is either green or red based on criteria of number of training courses left to complete in fiscal year

Some things to note (or maybe they're problems??):

My fiscal year is from Oct - Sep.  Some of my fields of the date columns are blank. I do have a calendar table set up but I'm not sure exactly how to use helper tables.  Below is an example of the training table:

Name	Requirement Complete Y/N	Due Date	Completion Date
Smith	Y	5/1/2023	5/31/2023
Anderson	N	11/2/2022
Allen	Y	8/31/2023	6/1/2023

[grazitti_sapna]

Hi @ejneyman 

For % Complete, You can try using 

% Complete =
DIVIDE(
COUNTROWS(FILTER(TrainingTable, TrainingTable[Requirement Complete Y/N] = "Y")),
COUNTROWS(TrainingTable)
)

For % Remaining, use the following measure:

% Remaining = 1 - [% Complete]

Create a KPI visual based on the number of courses left to complete in the fiscal year:

Courses Left =
COUNTROWS(
FILTER(
TrainingTable,
TrainingTable[Requirement Complete Y/N] <> "Y" &&
YEAR(TrainingTable[Due Date]) = YEAR(TODAY()) &&
MONTH(TrainingTable[Due Date]) >= 10
)
)

Thank you. Hope this will help you.