cancel
Showing results for
Did you mean:  ## 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  Solution Supplier

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!

2 REPLIES 2  Solution Supplier

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!  Yes, perfect, that's how it worked for me. Thank you so much!!!   