- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Field missing aggregate symbol
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.)
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yes u r correct . data cleaning is more important.
If u go with Power BI desktop we have several option to clean your data.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-22-2024 04:46 AM | |||
09-04-2020 06:44 AM | |||
01-01-2025 09:42 PM | |||
12-04-2023 09:33 AM | |||
03-13-2025 05:53 PM |