To display country-by-country compliance metrics for the most recent batch, you need an aggregated country breakdown (Pass, Fail, Total per country) plus top-level summary cards (Highest Pass Country, Highest Fail Country).
Step 1: Pre-calculate the Country Metrics on Screen Load
Using GroupBy and AddColumns in Power Apps produces clean country-level analytics without slow repetitive delegation calls.
On Screen_GeoCompliance.OnVisible (or right when navigating to the screen), add this formula: