Help with Formula/ Power Query to calculate Precision and Recall metrics

Hi Team,

I have the coding data generated by an automated model and then the coding data being generated by a human agent..I want to compare the same to generate the two metrics -precision and recall...In my input file the data is at a ctextid ,vbillid level...I need to compared the agentcode -code generated by human versus the predictcode (code generated by human)..

The precision metric is calculated as follows: Overlap of count of codes between agentcode and predictcode/ len(predictcode) *100
The recall metric is calculated as follows:Overlap of count of codes between agentcode and predictcode/ len(agentcode) *100

Can you please help me here...

Thanks,
Arun