Forum Discussion

lawada4's avatar
lawada4
Frequent Visitor
3 years ago
Solved

dax calculation total is incorrect

im trying to calculate return on investement for stocks data based on the formula ( current price-initial cost)/initial cost.  i calculated first the initial cost ( purchased amount * number of stoc...
Date
DAX
DAX Calculation
DAX Date condition
DAX Total
Total Measure
Total not matching
Total wrong
  • Syk's avatar
    Syk
    3 years ago

    The total column does not by default sum the total of the rows above in Power BI. Alberto explains it much better than I could attempt to - https://youtu.be/6rgAkejrup8

AilleryO's avatar
AilleryO
Icon for Memorable Member rankMemorable Member
3 years ago

Hi,

 

As mentionned by Syk the total of a table in Power BI is the same calculation as the one for the lines/rows except the filter coming from the lines.

To get back the Row context (which I think you need), you should replace your SUM by SUMX to restore a row by row calculation (iteration).

To get more details, you can watch the video.

Hope it helps and do not hesitate to share your formula with other members that could face the same situation or tell us if you need more help.