Forum Discussion

findingsolution's avatar
findingsolution
Helper I
4 years ago
Solved

Card not showing sum

I am trying to get the sum of the column 'Current Cost' in the card called 'Total Value':       If I only select some of the stocks (for example A2M), it will sum the value. But there seems...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    findingsolution 

    pls try this

    sum = 
SUMX ( 
     VALUES(Stocks[Stock List]),
     [current cost]
)
YukiK's avatar
YukiK
Impactful Individual
4 years ago

For Current Cost, try using SUMX() like the following:

 

Current Cost = 
SUMX ( 
     VALUES(Stocks[Stock List]),
     [Yesterday Close]*Stocks[Amount of Shares]
)
findingsolution's avatar
findingsolution
Helper I
4 years ago

When I try it, it shows an error:

 

 

That's why I previously used selectedvalue around the amount of shares, but when I try it, the card still does not sum. How do I fix this error?

 

PS: amount of shares is a whole number.