if country has ID then display as Y for respective status and count only Y in the total.
please find below data
You can create a calculated column with IF condition.
Column = IF(Table[ID] <> BLANK(), "Y","N")
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!