Forum Discussion
Solved
SUM/Count in Power Bi
Hi, I was wondering if there is a way to sum my sales data instead of it showing the count in PowerBi. I want to look at the sum of sales instead of the count in some of my charts.
Well I believe the error message says it all. The HMO[Sales] field is a text field - not a numerical field. You have change the type of the field first.
Please give more details. What exactly didn't work, where are you stuck? Maybe a couple of screenshots with the definition and the way you're trying to use it would help.
Hi, I am trying to show the Sum of Sales. My fields are Market, Partner, and Sales. When I move the sales in the values spot it is showing the count of sales. I would like to see the Sum of Sales or have a field with the
Sum of Sales so I can use it to create additional visualizations. I hope I explained it right.