Field missing aggregate symbol

[jel888]

Hello,

I've cleaned and imported a workbook with one worksheet and 11 columns (fields).  All of the fields except one have the Aggregate symbol (sum symbol) in the Fields list except one.  I've gone back and made sure that the formatting is the same (number) and the header to the column (field name) has the same formatting (standard) as the others and reimported the file (after deleting the first file).  The same field still show no Aggregate symbol.  Why is this and will it affect my reports (I presume yes.)

[v-yuezhe-msft]

Hi @jel888,

Glad to hear that the issue is solved. You can accept your own reply as solution, that way, other community members would easily found the solution once they get same issues.

Thanks,
Lydia Zhang

[cjlpowers]

I am seeing the same issue. I have verified all data is numeric by loading the CSV in Excel and using the ISNUMBER function to test all rows. The field was classified properly when the dataset was first imported however something changed over the last few days. I think this may be a bug as I dont see any other reason for the change in behavior.

[jel888 · Accepted solution]

Found my answer (after thinking a little bit), there was a letter in place of a number in one cell in the given column that forced the entire column's data to not be recognized as a numeric data.  So I performed a better cleanup and reimported into Power BI.

[Baskar]

yes u r correct . data cleaning is more important.

If u go with Power BI desktop we have several option to clean your data.