Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!!!
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
63 | |
62 | |
52 | |
39 | |
24 |
User | Count |
---|---|
84 | |
57 | |
45 | |
42 | |
37 |