Count then multiply

[JimmyHussein]

I have 2 tables 1:many 

The sales table which only has the units sold...  so each row counts as a sale...  the sales table doesn't have a quantity column 

My product table has the product key which exist in the sales table as well

I want to count the number of units per product key and then multiply it by the price of each product key from my product table 

Doing the total sales by unit must be done with count as I can't use sum

I can get the count but am struggling to get the revenue with the multiply 

[amitchandak]

@JimmyHussein , Try like

sumx(summarize(product, "_1",calcuate(sum(sales[quantity])) , "_2",calcuate(sum(product[price]))), [_1]*[_2])

[wdx223_Daniel]

=sumx(producttable,producttable[price]*calcuate(sum(salestable[quantity])))

[MattAllington · Accepted solution]

Try this

SUMX(productsTable,productsTable[price] * CALCULATE(COUNTROWS(SalesTable)))