Forum Discussion
Solved
Have row sum appear as a static column
I am trying to have the individual row values appear in one column and then the sum appear in the second column for each row. I can't get it to work. Any suggestions. An example is below. 19 is ...
Forgive me, are you trying to have the second column show as 19 or as the sum for that row? If the former, you'd use
Total = CALCULATE( SUM(Table1[Values]),all(Table1[Values]) )Looks like this:
If you are looking for the latter, you can use a formula like:
Total = Table1[Values]
But if that's what you're looking for I suspect there's a deeper question that makes it more complicated :smileyvery-happy: Let me know if it helps.
Forgive me, are you trying to have the second column show as 19 or as the sum for that row? If the former, you'd use
Total = CALCULATE(
SUM(Table1[Values]),all(Table1[Values])
)Looks like this:
If you are looking for the latter, you can use a formula like:
Total = Table1[Values]
But if that's what you're looking for I suspect there's a deeper question that makes it more complicated :smileyvery-happy: Let me know if it helps.