Forum Discussion

findingsolution's avatar
findingsolution
Icon for Helper I rankHelper 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
Icon for Impactful Individual rankImpactful 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
Icon for Helper I rankHelper 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. 

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    4 years ago

    findingsolution 

    pls try this

    sum = 
SUMX ( 
     VALUES(Stocks[Stock List]),
     [current cost]
)
    • findingsolution's avatar
      findingsolution
      Icon for Helper I rankHelper I
      4 years ago

      works a charm, thank you!

      • ryan_mayu's avatar
        ryan_mayu
        Icon for Super User rankSuper User
        4 years ago

        you are welcome