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)))

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

Try this

 

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