Calculate rate between columns in different tables at the row level

[Anonymous]

I have Leads in one table and Inventory count in another.  I need to calculate the rate of leads per inventory at a daily customer grain.

using  Leads per Listing = SUM(Leads[LEADS])/SUM('Listings Inventory'[INVENTORY])  is returning a single value for all rows.  Please Help.

[v-easonf-msft]

Hi, @Anonymous 

If you try to create calculate column，just try formula as below:

Leads per Listing1 = DIVIDE(LEADS[LEADS],RELATED('Listings Inventory'[INVENTORY]))

If you are creating the following measure but do not get the correct result, 

Leads per Listing = SUM(Leads[LEADS])/SUM('Listings Inventory'[INVENTORY])

please make sure that the types of the fields in table visual  are "Don't Summmarized"

pbix attached

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[az38 · Accepted solution]

@Anonymous 

its correct. but if you create a measure it will enable row context

 Leads per Listing Measure = 
DIVIDE(
CALCULATE(SUM(Leads[LEADS])),
CALCULATE(SUM('Listings Inventory'[INVENTORY]) )
)

and make sure you have appropriate relationships between your tables