DAX formula revision to show % of courses completed

[Anonymous]

Hello everyone,

I had a thread about a week ago that was trying to get help with putting together a table to compile users from my data set and show how far they'd progressed through a bundle of trainings (i.e. if someone completed 4 of 5 trainings in a training bundle, they'd be 80% complete). 

I need to track the people who aren't at 100% so we can follow up for compliance reasons. A user on this board was SUPER helpful in getting me most of the way there, but I'm stuck at the finish line here. 

Here are the DAX formulas I'm using:

% Completed = DIVIDE ( [Count Course Completed], [Count Course Completed] + [Count Course Outstanding] ) 

Count Course Completed = CALCULATE ( [Count Course], course_completions_report[Completion Status] = "Complete" )

Count Course Outstanding = CALCULATE ( [Count Course], course_completions_report[Completion Status] <> "Complete" ) 

Count Course = COUNTROWS ( course_completions_report ) //base measure

The final formula that's meant to show the % complete for a given training bundle is the % completed DAX formula, but it's actually only returning users at 100% complete. I need it to either show ALL user completion percentages (up to and including 100) or the opposite where it will only show people below 100%. 

I'm not sure what I'm doing wrong here, so I'd really appreciate some help if anyone has any insight as to where I'm going wrong. I'm happy to answer any clarifying questions as well.

Lastly, thanks to everyone on the forum for your continued help, this is been an invaluable resource to help learn how to utilize this program! 🙂

[parry2k]

@Anonymous hey can you share sample data and expected output and will get it over the line, if possible send pbix file with sample data.

[Anonymous]

@parry2k 

Hey there, I have just finished creating a sample data set in Power BI along with 2 tables to illustrate where I'm stuck. What's the best way to share the Power BI file? I'm still new to Power BI and not sure if I need to publish this or if I can just share the .pbix file with you/the forum. 

I'll share out the file once I'm clear on the correct way to do so. Thank you! 🙂

[parry2k]

@Anonymous either you can share thru onedrive/google drive or feel free to send it by email, my email is in signature.