Forum Discussion

JimmyHussein's avatar
JimmyHussein
New Member
5 years ago
Solved

Count then multiply

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 wh...
  • MattAllington's avatar
    MattAllington
    5 years ago

    Try this

     

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

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
5 years ago

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