Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
82 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |