Forum Discussion
Completion Rate Visual
Hello, I am new to PowerBI and currently doing a wireframe for a project. May I know how to calculate the completion rate based from my dummy data? Thank you so much!
Hi, I tried to paste the table last time but it got an error. I'll try again now.
Completion rate in a card format. Just the percentage of people who completed the training. Thank you so much!
| Employee ID | First Name | Last Name | Training ID | Start Date | Status |
| 1000 | Juan | Dela Cruz | EXL-0001 | 1-Jan | In Progress |
| 1001 | John | Doe | PYT-1234 | 13-Jun | Completed |
| 1002 | Allie | Grater | SFTY-4321 | 1-Oct | Overdue |
| 1003 | Olive | Yew | SFTY-4322 | 14-Jun | Completed |
| 1004 | Teri | Dactyl | PYT-4321 | 23-Feb | Completed |
| 1005 | Philip | Vega | PYT-4321 | 23-Feb | In Progress |
| 1006 | Dahlia | Ayala | SFTY-4322 | 14-Jun | Overdue |
Hi,
Write these measures:
Total = distinctcount(Data[Employee ID])
Completed = calculate([Total],Data[Status]="Completed")
Completed (%) = divide([Completed],[Total])
Drag the Completed (%) measure to the card visual.
Hope this helps.