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.
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.
@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])
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.
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
We want your feedback!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
A Year in Review - December 2024
Find out what content was popular in the Fabric community during 2024.
