Dividing rows/measures

[JNelson]

Hello,

I have data pulling through from an online source of our accounting system. I am trying to divide each row's [Cost] by [Quantity Produced] to get a unit rate. I am having trouble getting it to calculate for each row, it's only producing the Total unit rate. I have a filter applying to the date of the data too. 

Example of the data:

[Quantity Produced] = 3,000

Material/Account Code	Cost	Current outcome	Ideal outcome (Cost / Qty)
Material A	$40,000	infinity	$13.33
Material B	$60,000	infinity	$20.00
Material C	$5,000	infinity	$1.67
Material D	$2,000	infinity	$0.67
Total	$107,000	$35.67	$35.67

Thanks in advance!

[amitchandak]

@JNelson , You should not use measure in calculated column you should create a measure

divide([Qty Meausre], Sum(Table[Cost])

Line level measure

Sumx(Table, Divide([Qty Measure], [Cost])

or

AverageX(Table, Divide([Qty Measure], [Cost])

[JNelson]

Thank you @amitchandak .

So it is not possible to get the unit rates against each item? I've tried each dax you provided and they're not working. Could it be because the Cost and Quantity measures are in different tables?  The SUMX formula just yields blank entries in the table.

Thanks

[amitchandak]

@JNelson , Not if cost and QTY are from the different tables we should try to have a new column,

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

or use summarize of values in the measure

Assume there is a common table item

Divide(sumx(summarize('Item', "_1", calculate(Sum(Table1[Cost]) * Sum(Table2[Qty]) ) ),[_1]),Sum(Table2[Qty]) )