Create a Calculated Column Based on 2 tables

[Anonymous]

I have this created this table which is a Union of several other tables. 

I want to add a Cost per INQ (top row example for Blackhat = $112,139 / 444 INQs = $252.56 = Cost/Inq) as a column on the end of this table. What is the best way to do this?

[Anonymous · Accepted solution]

is both Cost and INQ columns are in the same source table ?

Option 1: you can create a Column in Power Query Editor

Option 2: create a measure as follows:

       Cost Per INQ = Cost - INQ

and drag it to this table Visual.

am not sure if am missing something but looks simple to me based on what you have provided below.

Thanks!

[Anonymous]

Without knowing how the data is set up, I'm not sure if this will solve your problem, but a measure built something like this should get the desired result:
Measure = 
DIVIDE (
    SUMX( table, table[cost]), SUMX( table2, table2[INQ]), 0)