How to calculate total prices from different product in different table

[User38690]

Hello, 

I have two tables Prices and Sales. In the first table I have all product list with the prices in the other one a have the list of the sales with the columns date, products, vendor, shop, region, quantity. What I want to do is to calculate all amount of the sales. I try to do the matrix when in the columns I put month, region, shop, product and vendor. I create the measure: TOTAL_SALES = SUM(sales[quantity]) * SUM(product[price]), but I get very large number that is not true. When I expend matrix until products I got real numbers. So my guess is that it first adds up all the prices and products quantity and the do multiplication. So how can I solve this problem?

(The first column is quantity the other one total price)

[vs_7 · Accepted solution]

Hi @User38690 

try below dax measure for calculating the total prices

TOTAL_SALES = 
SUMX(
    Sales,
    Sales[Quantity] * RELATED(Products[Price])
)