Dax help needed

[Cindy_346]

Hi There,

I am having some trouble with a formula, basically I am trying to calculate weightage of total by Opt Country 

which is taking "Total" per Nationality divided by the subtotal (Opt Country), so for example my desired result will be for Indian Nationality for Opps to be 3496/5506 = 63.49% and this shld be the same for Indian Nationality for Enrolled  which is taking 56/58 = 96.55%,

if there is a way to achieve this will be great, thanks for your help!

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...