DAX Row Level subtotals not appearing

[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. 

[tamerj1]

Hi @hitesh1607 
I guess you already have a relationship between both tables or otherwise you can easily create one. Then you can iterate over sales:

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

[hitesh1607]

Hi

I used related in the first place. I am getting WeightNy (2.28) * Quantity (3104) = 18,889.80 (it should be 7077.12)

[tamerj1]

Hi @hitesh1607 
Would you please clarify the issue further? Can you please share some screenshots about your data model or maybe any insensitive data from both tables? Can you please share the code that you used?