topic Count then multiply in DAX Commands and Tips

Count then multiply

JimmyHussein — Sun, 29 Nov 2020 16:13:23 GMT

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

MattAllington — Sun, 29 Nov 2020 19:51:59 GMT

Try this

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

wdx223_Daniel — Mon, 30 Nov 2020 00:49:16 GMT

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

amitchandak — Mon, 30 Nov 2020 04:06:57 GMT

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