calculating the sum of Measure

[jdelacrettaz]

hello good afternoon, I have a question that I can not solve. I have 2 tables in which in one I have all the sales with each article and another table with the data of the articles where I have the weight, etc. I need to get the amount of kilos per sale and I did the function. Quantity x weight = sum (salesxdia. [Quantity] * sum (article. [Weight]) Now what you are doing to me is multiplying the total sum of weight by the total sum of quantity.  I need a formula to add the column quantity x weight

I need this result

[v-frfei-msft]

Hi @jdelacrettaz ,

SUMX should help you in your scenario. Please create a measure like this to work on it.

Measure = SUMX(Your table, [sum])

If it doesn't meet your  requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

[parry2k · Accepted solution]

@jdelacrettaz there are few way to solve this but this is easiest assuming your sales relationswhip with article table is one to many, one on article side and many on sales side. If this is the case, just add new column in sales table using following DAX and then do the sum on this column in your visual

Qty with Weight = 
Sales[Qty] * RELATED ( Article[Weight] )