Forum Discussion
Helper IITotals doesn't match with matrix rows
Hi All,
I have a problem and I need your help. I am working on a calculations of PxQ (price x quantity). On rowlevel it works, but on total level it doesn't add up. The totals are much higher than the sum of the rows.
The calculation is as below:
Q avg last 2 months gives the average of the number of products of the last months (Finance wants it that way).
P is the price.
Can anyone help me out, so the totals match up with the sum of the rows, please?
For example: In the matrix the column on the right says 305.846,76, but the rows only sums up to 223.425,55
please find attached the link to my test dashboard:
Hi,
Drag this measure to the visual
Measure = SUMX(VALUES(data[productid]),[PxQ])Hope this helps.
5 Replies
- Ashish_Mathur
Super User
Hi,
Drag this measure to the visual
Measure = SUMX(VALUES(data[productid]),[PxQ])Hope this helps.
Sander1401You are a lifesaver! Thank you very much!
- Ashish_Mathur
You are welcome.
m4niResolver I
Sander1401 , this is not uncommon in Power BI. Usually requires investigation at a more granular level. Its difficult to respond with exact solution but I would suggest if you can look at a specific row or ID example to try and understand what the measures / totals are doing. It may become evident like this. HTH
- m4ni
Maybe filter you matrix and measure to the same rows to understand...