Forum Discussion

fergmn's avatar
fergmn
Frequent Visitor
3 years ago
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. 
Need Help
Tutorial Requests
  • JirkaZ's avatar
    JirkaZ
    3 years ago

    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's avatar
fergmn
Frequent Visitor
3 years ago

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's avatar
fergmn
Frequent Visitor
3 years ago

 

 

  • JirkaZ's avatar
    JirkaZ
    Solution Specialist
    3 years ago

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

    • fergmn's avatar
      fergmn
      Frequent Visitor
      3 years ago

      Hi JirKaz, 

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

       

       

       

       

      • JirkaZ's avatar
        JirkaZ
        Solution Specialist
        3 years ago

        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?