cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

1 ACCEPTED SOLUTION
Super User

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!

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

4 REPLIES 4
Super User

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!

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

New Member

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - July 2024

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

#### Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors