Dividing between two related tables

[Niiru1]

I currently have 2 tables: Sheet 1 and Census data.

I have built the census data to show:

Census Data Age/Gender = 
DATATABLE(
 "Age Group Name",STRING,
 "Male",INTEGER,
 "Female",INTEGER,
 "Total",INTEGER,
 {
 {"0-4 yrs",169731,161784,331515},
 {"5-14 yrs",344848,330189,675037},
 {"15-24 yrs",292492,283960,576452},
 {"25-34 yrs",318401,341009,659410},
 {"35-44 yrs",368527,378354,746881},
 {"45-54 yrs",311036,315009,626045},
 {"55-64 yrs",252556,256402,508958},
 {"65-74 yrs",184462,189046,373508},
 {"75-84 yrs",89313,107191,196504},
 {"85+ yrs",23062,44493,67555}
 }
)

What I'm trying to do is take the count per age group in Sheet1 and multiply it by the Total in the census table

e.g. first value of 0-4 yrs  is 5 therefore (5/331515)*100000 = 1.5

Thanks in advance

https://www.dropbox.com/s/c3hfci8jabydxv1/Pareto.pbix?dl=0

[negi007 · Accepted solution]

@Niiru1  Below try to use the below solution

1. You can unpivot the data in the second table like below. have one column for age group

2. Then create relantionship between two tables on age group columns

3. create your measure like below

Formula_output = SUM(Census_Data_Week[Value])/SUM('Census Data Age/Gender'[Total])*100000

4. You will get below output using the matrix visual.