Forum Discussion
SUM/Count in Power Bi
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.
Solution SpecialistSure - create a measure for whatever calculation you need.
Example (Sum of sales amount):
My Sales Amount := SUM('MyFactTable'[Sales Amount])Do I create this measure before inserting any graphs?
- JirkaZ
Creating Measures (calculations) is part of the data modeling/preparation. So you do that before you visualize the data.
Hi JirkaZ,
I tried the measure MySalesAmount:=SUM(HMO[Sales]) and it didn't work am I do doing something wrong.
- JirkaZ
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.
