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
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

In the simple table that you have shared, what should the figure be for the denominator i.e. total trainings?  If you wanto to ignore all rows where due date > last date of today's month i.e. 28 Feb 2021, then the denominator will be 0.