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
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi  Anonymous ,

Here are the steps you can follow：

1. Create measure.

Measure =
var _com=CALCULATE(COUNT('Table'[Completion Status]),FILTER(ALLSELECTED('Table'),'Table'[Completion Status]="Completed"))

var _all=COUNTX(ALL('Table'),'Table'[Completion Status])
return
IF(MAX('Table'[Due Date])<=MAXX(ALL('date'),'date'[Date]),DIVIDE(_com,_all),BLANK())

2. Place Date in Axis, Completion Status in Legent, and Measure in Values

3. Result.

 

You can downloaded PBIX file from here.

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.