Column of numbers won't sum

[garricksullivan]

Hi!

I'm experiencing an issue where I have a column that is already set to Whole numbers, and all of my other columns are also set to whole numbers, yet the one column will not sum when I bring it into a visualization. It also won't have the Greek Sum symbol appear next to the line when I'm manipulating data, but when I got into edit queries, it shows that it is a number.

How do I solve this?

Thanks!

[jdbuchanan71 · Accepted solution]

In the table you can set the summarization behavior for a column.  My guess is it's set to 'Don't summarize' for the column that is causing you problems.

If this solves your issues please mark it as the solution. Kudos 👍 are nice too.

[JaclynPugh2022]

What if it's a measure and not a table column that won't sumamrize?  

[v-chuncz-msft · Accepted solution]

@garricksullivan 

You may also try Change how a numeric field is aggregated and use SUM to add a measure.

[jdbuchanan71 · Accepted solution]

In the table you can set the summarization behavior for a column.  My guess is it's set to 'Don't summarize' for the column that is causing you problems.

If this solves your issues please mark it as the solution. Kudos 👍 are nice too.