Is it possible to multiply a column to a measure (before aggregating the column) ?

[yoyfreddy]

I wish to multiply each "Price" column value with measure "SUM(Sales Volume) of the same product", and then calculate total revenue.

We all know (A+B) * (C+D) ≠ (A*C) + (B*D), so a typical Calculate(SUM[Sales Volume])*Price doesn't work in my case.
Is there any possible syntax to calcualte the total revenue correctly?

Price Table

Product	Price
A	10
B	20
C	30
D	40

Sales Table

Product	Sales Date	Sales Volume
A	Jan	1
B	Jan	2
C	Jan	3
A	Feb	4
B	Feb	5
C	Feb	6

Intended outcome

[AntonioM · Accepted solution]

Hi, 

I think this will give you your intended outcome, assuming you have a relationship between 'Price Table'[Product] and 'Sales Table'[Product]

Measure = SUMX('Sales Table', 'Sales Table'[Sales Volume] * RELATED('Price Table'[Price]))

[yoyfreddy]

@AntonioM  It works, Thank you !!