Forum Discussion
Dividing between two related tables
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",INTEGE...
Anonymous 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])*1000004. You will get below output using the matrix visual.
negi007
Community Champion
Community ChampionAnonymous 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.