Divide summed income on store area

[gkalandadze]

Hey,

i'm new. need help

Got this situation : these are different tables, I need to divide sum of each branch income on a branch area.
example Poti 68/100
thanks in advance

[Pulkit]

Hi,

Create a new column on the table with Area using this DAX.

Column = CALCULATE(SUM(Table1[Sold]))/Table2[Area]

[gkalandadze]

no it doesn't work. it can't include table2 (((

[Pulkit]

What's the error?
Is there any relationship between these two tables?

[gkalandadze]

yes there are relationship between them. but shows an error

[Pulkit · Accepted solution]

Dude you need to change the table names.

[gkalandadze]

thanks man!