Forum Discussion
Solved
Columns don't aggregate
Hi, I have a problem with my report - my columns don't aggregate. The Summarization is set to Sum and still I see no sum icon next to the column and it acts like text once I drag and drop it to a t...
The isue turned out to be a result of using Calculation Groups in the model.
More on that problem in my old post:
Dynamic formatting of measures - tutorial - Microsoft Power BI Community
did you checkin power query ? what is the data type over there?
Maybe the column has null values and when it imports it is not recognized as numbers because of that.
I would take a look at the column in query editor and make sure it is set as Whole Number
