Calculation

Hi, sks2701 

According to your description, you can try these measures:

Dropped Rate =

var _tatalcount=COUNTX(ALL('Table'),'Table'[ID])

var _droppedcount=COUNTX(FILTER('Table',[Overall Status]="Dropped"),[ID])

return DIVIDE(_droppedcount,_tatalcount)

Closed Rate =

var _tatalcount=COUNTX(ALL('Table'),'Table'[ID])

var _closedcount=COUNTX(FILTER('Table',[Overall Status]="Closed"),[ID])

return DIVIDE(_closedcount,_tatalcount)

Approval Rate =

var _tatalcount=COUNTX(ALL('Table'),'Table'[ID])

var _approvalcount=COUNTX(FILTER('Table',[Overall Status]="In progress"||[Overall Status]="Under review"),[ID])

return DIVIDE(_approvalcount,_tatalcount)

You can set the measure type to “Percetage”, like this:

And you can get what you want, like this:

You can download my test pbix file here

Best Regards,

Community Support Team _Robert Qin

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