Forum Discussion
Helper Imultiply column and a measure - wrong total
Hi There,
i am trying to multiply the total quantity of the items with the number of orders (frequency) but in second screenshot total is 190 instead of 86 (64+22)
can you please help to fix that total, i have spent 2 days and couldnt figure out the error.
thanks in advance
best regards
tim
24 Replies
vicky_Super User
Technically, your measure is doing what you've asked it to do (multiply the value in the quantity by the value in the frequency), and this applies to the total row too. Of course, this isn't the result you want. Greg Deckler has a very in-depth write-up on how to solve this issue with measures. Link here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/m-p/63376/highlight/true#M56
timurcakinHi Vicky,
thank you very much for the guidance but the link is not giving a definite answer either.
let me ask this way, is there a way to:
1- multiply product quantity * number of orders = frequency
2- take weighted average of products (based on frequency)
appreciate your feedback
- Ashish_Mathur
Hi,
Share the download link of the PBI file.
- timurcakin
Hi Ashish,
i modified it a bit as it was connected to the database.
but ultimately what i want to do is to divide "measure3" per line to grand total of "measure" (which is wrong or not what i want in the file)
i want to see 31,214,080 instead of 5,221,978,332
hope that make sense
thanks in advance
timur
- Ashish_Mathur