Forum Discussion
Finding Percent Complete by course by division
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
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.
Hope this will be helpful :)
Sure!
I've hidden some columns with personal data and to help fit the data on one screenshot. The column "completeincomplete" was created the converted some courses statuses that were other than Complete to Incomplete (done in excel but would be easier done in PowerBI but not sure how to do that).
Let me know if that helps,
Thanks again... Ray
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
Also you can add conditional column in power bi to calculate value for "complete in complete" column, it is pretty staright forward.
here are the steps:
1. Click edit queries
2. Goto "Add Column" Tab
3. Select condition column
and that is where you put the condition to calculate this column
Cheers,
P
I came up with the following but for some reason, it returns an error..
CourseStatusNew = IF(SEARCH('UoM-report'[Course Status],"Completed"),"Completed","Incomplete")
Basically what I want it to do is search the Course Status column and if it has a status of Completed, then the result is Completed, if it is anything other than complete (such as in progress or not yet started or extempted, etc) to set it as Incomplete.
Thoughts?
Here is what I think you need
CourseStatusNew = IF(SEARCH("Completed", 'UoM-report'[Course Status]),"Completed","Incomplete")