Trying to divide a measure by a field in a separate table

[AaronGlenn10]

I have measure which calculates cumulative (12 month) of sales for a city -- and, I have the population for that city in a separate table ["Demographics"].  Trying to create a measure which divides the cumulative sales by the city's population so I can get a per person sales figure.

Thank you!  ~AGS

[v-xiaotang]

Hi @AaronGlenn10 

Thanks for reaching out to us.

Try this, (supposing the name of your measure is measure1)

(1) create a table visual, and put city field from Sales into it

(2) create the measure and put it into table visual

SalesPerPerson=
    var _population = CALCULATE(MAX(Demographics[population]),Demographics[city]=MAX(Sales[city]))
return [measure1]/_population

If this doesn't help, then you may need to make small changes to your measure, 

Could you share

(1) measure which calculates cumulative (12 month) of sales for a city

(2.1) a sample file

(2.2) or post some sample data in text, e.g.

Sales

date	city	sales
2021/1/1	city1	1
2021/2/1	city2	2
?	?	?
?	?	?

Demographics

city	population
city1	2
city2	3

(3) expected result

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[AaronGlenn10]

Thank you!