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.
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?
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.