Forum Discussion
Writing a measure between 4 different tables
sorry about before. I had to run and didn't want to give you another wrong answer, so I needed to test. This should work
=sumx(size,CALCULATE(sum(Orders[Qty])) * size[Size])
edit: Sorry, this next one is better and what I had in mind originally
=sumx(Orders,Orders[Qty] * RELATED(size[Size]))
Just rename the columns you need
Best to avoid calc columns if you can. It's not wrong, just better http://exceleratorbi.com.au/calculated-columns-vs-measures-dax/
I calculated the Cube for each line item in the Sales Order by creating a Calculated Column = Order Qty * Cube Size. So now if I want to create a measure that adds up the total cube for each Sales Order, how would I script that?
Community Championsorry about before. I had to run and didn't want to give you another wrong answer, so I needed to test. This should work
=sumx(size,CALCULATE(sum(Orders[Qty])) * size[Size])
edit: Sorry, this next one is better and what I had in mind originally
=sumx(Orders,Orders[Qty] * RELATED(size[Size]))
Just rename the columns you need
Best to avoid calc columns if you can. It's not wrong, just better http://exceleratorbi.com.au/calculated-columns-vs-measures-dax/