I am working with SUMX for the first time and with two different tables.
Yes, I have look at other similar posts, and my formula isn't throwing errors, but it isn't getting the correct result.
I have two tables - Dimensions has a SKU number, height, weight, length and width. Each SKU is unique
Orders has Order Number, SKU number, quantity, and then several other columns not needed for this calculation.
I am trying to figure out the average weight of orders per day.
Here is my formula -
New Measure Try = sumx(Orders,Orders[Quantity] * AVERAGE('Dimensions'[weight]))
This is getting larger numbers than when I do it in Excel. Is the "Average" the issue? I can't seem to tell it to do SUMX without using some kind of calculation for the second table. The two tables have a one-many relationship, with Dimensions being the one.