Sum dynamically a column

[Anonymous]

Hello Folks,

I have the following data structure (already unpivoted)

In PowerBI Desktop, I am getting the cont of value however my requirement is to get the sum of "Shares Book Value" which should "423455" in this case.

Tried to create a new Quick Measure (Running Total, Total for category, Addition) but could not succeed.

Thanks.

[amitchandak]

@Anonymous , Make sure the value column is of Number type Whole number/Decimal. Else change it. Then you can Sum it up.

Measure = Sum(Table[Value])

[jdbuchanan71 · Accepted solution]

In Power Query change the data type of the value column to number.

Then in PowerBI you write a measure to sum that column

Total Value = SUM ( YourTable[Value] )

Then add that measure to your visual.