Forum Discussion
JNelson
Helper II
Helper IIDividing rows/measures
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 i...
JNelsonHelper II
Helper IIThank 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
Super User
Super UserJNelson , 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]) )