Forum Discussion
Help with formula for OCR testing
Hi antontirol ,
We can do some transformations in Power Query Editor and create a measure to meet your requirement.
1. We need to get the rank in each group. So we need to group the ID and add an index column in it.
2. Then we can copy the same table, one filters the ID to 1, another filters the ID to 2.
3. At last we need to merge table and table 2, then add a conditional column.
4. Then we need to create a measure to get the result.
Measure = DIVIDE(SUM('Table'[Custom]),COUNTROWS('Table'))If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BTW, pbix as attached.
Hello AllisonKennedy ,
I dont have index column but can sure make new.
I would like to describe more what im trying to achieve.
It is project for comparing text read by OCR from documents.
I have 2 tables which i merged together.
In one table are document as it should be from from pdf.
In second are data from OCR, there are many test on same documents with different settings. ID is different for different OCR settings.
This report should compare data from OCR and original data and show how many values are correct. Goal is to find which OCR setting works best.
Community Champion