Forum Discussion

Sander1401's avatar
Sander1401
Icon for Helper II rankHelper II
8 months ago
Solved

Totals 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 tha...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 months ago

    Hi,

    Drag this measure to the visual

    Measure = SUMX(VALUES(data[productid]),[PxQ])
    Hope this helps.

     

m4ni's avatar
m4ni
Icon for Resolver I rankResolver I
8 months ago

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