Completion Rate Visual

[randomcobbler]

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!

[Ashish_Mathur]

Hi,

At the very least, desribe your question propery.  What do you want to calculate the completion status by - Month, Employee ID, Training ID????????  Share data in a format that can be pasted in an MS Excel file.  Show the expected result very clearly.

[randomcobbler]

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

[Ashish_Mathur]

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.

[Anonymous]

Hi  @randomcobbler ,

Do you mean the completion rate for each month?

Here are the steps you can follow：

1. Create measure.

Measure =
var _count=
COUNTX(FILTER(ALL('Table'),
YEAR('Table'[Start Dates])=YEAR(MAX('Table'[Start Dates]))&&
MONTH('Table'[Start Dates])=MONTH(MAX('Table'[Start Dates]))),[Employee])
var _countcompleted=
COUNTX(FILTER(ALL('Table'),
YEAR('Table'[Start Dates])=YEAR(MAX('Table'[Start Dates]))&&
MONTH('Table'[Start Dates])=MONTH(MAX('Table'[Start Dates]))&&'Table'[Status]="Completed"),[Employee])
var _divide=
DIVIDE(
    _countcompleted,_count)
return
IF(
_divide=BLANK(),0,_divide)

2. Result:

If that result does not meet your expectations, you can express the expected result in the form of a picture and we can help you better.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly