Forum Discussion

hitesh1607's avatar
hitesh1607
Advocate II
4 years ago

Issue with Totals

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
Need Help

1 Reply

  • goncalogeraldes's avatar
    goncalogeraldes
    Super User
    4 years ago

    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