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.
JirkaZ
Solution Specialist
Solution SpecialistSure - create a measure for whatever calculation you need.
Example (Sum of sales amount):
My Sales Amount := SUM('MyFactTable'[Sales Amount])