Completion Rate Visual

Hi  Anonymous ,

 

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

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.