Data not Summarizing

[Dbstedman]

I'm looking for a way to sum the values into just East and West so I don't have four lines for each. I'm new to Power BI so it could just be an issue with how I imported my data. Is there something easy in the settings I missed or do I need to adjust my data import? Thank you

[ribisht17]

Check this one, 

Regards,

Ritesh

[Dbstedman]

I found my mistake. The number coloumns were set to "Don't Summarize". Thanks for the help!

[Pragati11 · Accepted solution]

Hi @Dbstedman ,

Whenever you move certain columns to Power BI table visual, if they are of numeric type they should summarise themselves by default to SUM.

What are the data-types of all the columns in your screenshot above?

[Dbstedman]

The first column should be text and the next three are whole numbers.