Forum Discussion
SUM/Count in Power Bi
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.
Well 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.
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.
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.
This definately solved my issue. Thank you so much.