Issue with Totals

[hitesh1607]

Hi

I have two tables.

Product: Category, SubCategory, NtWeight

Sales: LineNo, Qty

I want to multiply NtWeight*qty  but I am getting either wrong subtotals or if I use SelectedValue function then row-level details are fine but Subtotals are blank in matrix visual.

Please help. 

I used

Total Weight = SUMX ( Sales, Sales[Qty] * RELATED ( 'Product'[NtWeight] ) )

but getting wrong results.  I am getting WeightNy (2.28) * Quantity (3104) = 18,889.80 (it should be 7077.12)

I also tried 

CALCULATE(SUMX('Product','Product'[NtWeight])*[Quantity]

(Measure created for the Qty)

Again wrong results.

Please help

[goncalogeraldes]

Hello there @hitesh1607 ! How is the relationship between the two tables made? Through ProductID? If so, in the example you have given, which ProductID is being fetched by the RELATED function?

For additional help, please @ me in your reply!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes