Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Help! How to show Training Completion % over time. Need help with measure and model.

Please help! New to Power BI. I need to show training completion % over time.  I do have a Calender table and a Fact Training table. My Training fact table column structure consists of: I assume ...
Need Help
negi007's avatar
negi007
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous You can have a measure like below to calculated completed training status 

 

Completion_Rate_N =
var max_dt = MAX('Calendar'[Date])
var tol_training =CALCULATE(COUNT(Completion[Class]),Completion[Due Date]<=max_dt)
var compl_train = CALCULATE(COUNT(Completion[Class]),Completion[Completion Status]="Completed",Completion[Due Date]<=max_dt)
return
DIVIDE(compl_train,tol_training,0)
 
Please ensure that in your date tables, the max date value should not be higher than due date. To ensure it while creating calendar tables. You could do the below
Calendar = CALENDAR(FIRSTDATE(Completion[Delivery Date]),LASTDATE(Completion[Due Date]))
 
here is the output, you are looking for.

 

I have attached powerbi file for your help as well