SUM/Count in Power Bi

[fergmn]

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. 

[JirkaZ]

Sure - create a measure for whatever calculation you need. 

Example (Sum of sales amount):

My Sales Amount := SUM('MyFactTable'[Sales Amount])

[fergmn]

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.

[fergmn]

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. 

[fergmn]

 

 

[JirkaZ]

Well you have to drop the measure to the Values section of the visual for it to work (replacing what's there currently)

[fergmn]

Hi JirKaz, 

So I tried the measure and exactly what you told me and this happened. 

 

 

 

 

[JirkaZ]

What does the "See details" say? Do you have relationships existing and working between the HMO table and any other table that you are trying to use in the visual?

[fergmn]

Hi JirkaZ, I am attaching a picture of what the 'See details' says, and I do not have a relati

 

 

onship set up. I do have 2 sets of data I am working with though, and will eventually use the 2nd set of data in my current page. 

[JirkaZ · Accepted solution]

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.

[fergmn]

This definately solved my issue. Thank you so much. 

[fergmn]

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.