Trying to Calculate pounds shipped

[Anonymous]

Hello Everyone,

I currently have a table that has SKUs and the weight in lbs for each particular unit. That table is then linked to a table of delivery information by SKUs summing how many units were shipped. I am having trouble getting a formula to multiple the two to figure out the total untis shipped. I thought it would be LBS. * Delivered but it is not working

[OwenAuger · Accepted solution]

Hello @Anonymous 

For this calculation, I would suggest iterating over the values of 'Manual SKU Table'[LBS.], and for each value of LBS. multiply by the related sum of Delivered, then sum.

(Below I've used the table & column names from your screenshot - correct if needed)

I would suggest first creating a Units Shipped measure:

Units Shipped = 
SUM ( 'Query 1 2'[Delivered] )

Then you can create a LBS Shipped measure looking something like either of these :

LBS Shipped = 
SUMX ( 
    VALUES ( 'Manual SKU Table'[LBS.] ),
    'Manual SKU Table'[LBS.] * [Units Shipped]
)

or

LBS Shipped =
SUMX (
    SUMMARIZE ( 'Query 1 2', 'Manual SKU Table'[LBS.] ),
    'Manual SKU Table'[LBS.] * [Units Shipped]
)

Does this work at your end?

Regards,

Owen