Finding Percent Complete by course by division

[rayinOz]

Hello All!

I  need help creating a chart that shows completion rate for course enrolments. This is the percentage of course status marked "complete" by course and by division. The previous employee did this manually and i'm looking for Power BI to help me do this more automatically.

I have the following relevant data columns in my data table (I have other columns such as student name, email, manager, etc):

Division

Course Name

Course Status (The data is text that is either "Complete" or "Incomplete"

Each row in the data is a course enrolment

Here is a screen grab of a chart that was created manually in excel using copy/paste and then imported into PowerBI. However, i'm looking to do this within PowerBI.

Thoughts on how to do this in PowerBI? Any help would be much appreciated.

Cheers,

Ray

[parry2k · Accepted solution]

No worries, I created a dummy data at my end, i can send you the file with formulas in it, basically in nutshell this is what I did:

created 3 measures to calculate

Total Completed

Total Completed = CALCULATE(COUNT(Student[Student]),FILTER(Student, Student[Course Status]="Complete"))

Total Courses

Total = CALCULATE(COUNT(Student[Student]))

% Completed

% Completed = [Total Completed] / [Total]

Added a column chart and added the value as below

and here is the output

You can change these formulas as per your data model and enhnace these as you feel like.

Cheers,

P

[parry2k · Accepted solution]

You are in edit query, not writing DAX formula.

As mentioned previously, go to add column tab, click conditional column and it will stratight forward from there. Try it and let me know.