divide sum of same elements (from one column) by total value for the element (under Totals column)

[Talos]

Hi,

I have a table with customers and their region (based on postcode).  What I am trying to do is divide the sum of the customers from that area to total population for that area (which I have in another table, each row having these fields, in this order: area name, area postcode, area total population)

Example:

table one

Customer1 - PK13 8JJ

Customer2 - TR11 7LN

Customer3 - IZ2 9TV

Customer4 - PK13 8JJ

Customer5 - TL1 4VS

Customer 6 - PK13 8JJ

table two

PK13 8JJ - 1254

KL12 4EW - 1711

IZ2 9TV - 1109

So I want: 3/1254 = 0.23%

Thank you!

[bhanu_gautam · Accepted solution]

@Talos , You can achieve this using DAX  create a measure

DAX
CustomerPopulationRatio =
VAR SelectedPostcode = SELECTEDVALUE(Table1[Postcode])
VAR CustomerCount =
CALCULATE(
COUNTROWS(Table1),
Table1[Postcode] = SelectedPostcode
)
VAR TotalPopulation =
CALCULATE(
SUM(Table2[TotalPopulation]),
Table2[Postcode] = SelectedPostcode
)
RETURN
DIVIDE(CustomerCount, TotalPopulation, 0)

And make sure there is relation between both table your both tables on basis of post code column