Forum Discussion
TomLU123
Helper III
Helper IIICount the Completed Task to track the completion rate
Dear Expert,
I have a data set like below to track the completion status of each task.
| Task | Assigned to | Status |
| Task A | Smith | Completed |
| Task A | Andy | In progress |
| Task A | Joe | Completed |
| Task A | Mandy | Not Started |
| Task B | Smith | Completed |
| Task B | Andy | Not Started |
| Task B | Mandy | Not Started |
I wish to create measrues to track the ①# of "Completed" of each task, ②the Completion Rate of each task (# of Completed/# of people this task assigned to). For example, the expected output would be like this:
| Task | # of Completion | Completion Rate |
| Task A | 2 | 50% |
| Task B | 1 | 33.30% |
Is it possible to create measures to achieve that?
Many thanks!
this code should work
# of Completed = CALCULATE(COUNTA('Table'[Status]), 'Table'[Status]="Completed") Completion Rate = DIVIDE([# of Completed], COUNTA('Table'[Status]))it counts the rows in the tablem so if the table you presented is an aggragation then additinal SUMMARIZE/GROUPBY will be necessary
1 Reply
- Stachu
Community Champion
this code should work
# of Completed = CALCULATE(COUNTA('Table'[Status]), 'Table'[Status]="Completed") Completion Rate = DIVIDE([# of Completed], COUNTA('Table'[Status]))it counts the rows in the tablem so if the table you presented is an aggragation then additinal SUMMARIZE/GROUPBY will be necessary