Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Syndicate_Admin
Administrator
Administrator

Incorrect total when multiplying columns

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

Captura de pantalla 2021-07-25 a las 19.18.01.png

1 ACCEPTED SOLUTION
Migasuke
Memorable Member
Memorable Member

Hi @Syndicate_Admin ,

This formula using sumx and related should solve your problem.
I have 2 tables. One with Price, second with Quantiy.

Migasuke_0-1627237450632.png

 


Take a look and let me know if it helped!



If my answer was helpful please give me a Kudos or even accept as a Solution.

Let's connect on LinkedIn!

View solution in original post

4 REPLIES 4
Migasuke
Memorable Member
Memorable Member

Hi @Syndicate_Admin ,

This formula using sumx and related should solve your problem.
I have 2 tables. One with Price, second with Quantiy.

Migasuke_0-1627237450632.png

 


Take a look and let me know if it helped!



If my answer was helpful please give me a Kudos or even accept as a Solution.

Let's connect on LinkedIn!

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!!!

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.