Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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!  
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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