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.
I've created a table where I show data from two tables.
Table 1: Name and price.
Table 2: Quantities.
So I'm left with a view: Name, quantities, price.
I have generated a new column that multiplies the quantities by the price using: Total = SUM('ps_product'[price])*SUM('ps_stock_available'[quantity])
I do well the multiplication, but in the total of the column I see an amount that has nothing to do with it. LLevo days going around, looking for forums and I can't find how to solve it. Can anyone help me? I've tried both SUM and SUMX
Solved! Go to Solution.
Hi @Syndicate_Admin ,
This formula using sumx and related should solve your problem.
I have 2 tables. One with Price, second with Quantiy.
Take a look and let me know if it helped!
Hi @Syndicate_Admin ,
This formula using sumx and related should solve your problem.
I have 2 tables. One with Price, second with Quantiy.
Take a look and let me know if it helped!
What if I have to multiply two measures?
Thanks Migasuke,
you have solved my issue I have spent half day trying to fix and googled myself to death, almost giving up.
My issue was a standard multiplication of Kilometers x emission factor = carbon created,
whereby the results was double the amount it should have been.
Your solution with SUMX & RELATED has fixed it.
LEGEND! Thanks again.
Yes, perfect, that's how it worked for me. Thank you so much!!!
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |