topic Re: DAX Row Level subtotals not appearing in DAX Commands and Tips

DAX Row Level subtotals not appearing

hitesh1607 — Fri, 18 Mar 2022 03:27:54 GMT

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.

Re: DAX Row Level subtotals not appearing

tamerj1 — Fri, 18 Mar 2022 03:45:32 GMT

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] ) )

Re: DAX Row Level subtotals not appearing

hitesh1607 — Fri, 18 Mar 2022 12:20:33 GMT

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

Re: DAX Row Level subtotals not appearing

tamerj1 — Fri, 18 Mar 2022 13:04:15 GMT

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?