Connect Matrix with table

[bipolarminds]

I have a table table1 with column postal_code. From this I created a matrix like this:

postal_code	#rows_in_table1
12345	6
12346	18
12347	23
...	...

Moreover, I have a different table table2 with columns postal_code and #households. I created a n:1 relation between table1 and table2 via the postal_code columns. Now in the above matrix, I would like to add a new column with values given by #rows_in_table1*100/#households, where #households should be taken from the respective postal_code. How can I achieve this? 

Of course I could add a new column in table1 with #households (same values for same postal_codes) and take the averages, max, min, etc... in the matrix, but there should be a cleaner way, right?

[lbendlin]

Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523