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 SpecialistWell you have to drop the measure to the Values section of the visual for it to work (replacing what's there currently)
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?
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.