Calculating percentages as a measure

[Anonymous]

 Hi, I have data by age group and gender. I want to plot a matrix table which will show the numbers and percentages for the age groups and gender. Please see the screenshot below for the example I did in Excel. 

I want to replicate the same table in Power BI. Can someone please help me with the formula. I am attaching the sample Power BI file for reference. https://1drv.ms/u/s!AubIV2PXG9p4gqlzKyaKWMAGV8dfBw?e=A4tYzT

Thank you

[amitchandak · Accepted solution]

@Anonymous , Please find the file attached after signature

[Anonymous]

@amitchandak Thanks a ton. You are a champ.

I just checked your YouTube channel. Looks good. Great effort.