Help for Multiply Query Formula

[zoe88]

Hi, i merged some tables. all values come out correct excep the bottom right total which is multiplying the qty x values but the total line should be the value of the columns added up.

[Ashish_Mathur · Accepted solution]

Hi,

Try this measure

Measure = SUMX(VALUES(Data[Product]),[Base rem + F rem * quantity])

I have assumed that Product is the first column of the visual.

Hope this helps.