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

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi lawada4 

please use

amount purchased value =


SUMX (
VALUES ( 'user portfolio'[Ticker] ),
CALCULATE ( SUM ( 'user portfolio'[number of stocks purchased] ) ) * [last closing price]
)