Forum Discussion

RafalK's avatar
RafalK
Advocate IV
5 years ago
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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

RafalK  Also make sure that the below option is selected

RafalK's avatar
RafalK
Advocate IV
5 years ago

Thanks but as you can see on my screenshot it is.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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

    • RafalK's avatar
      RafalK
      Advocate IV
      5 years ago

      Power Query sets the columns as a Whole Number data type. There are no nulls.

      The problem is not related to this column alone but to all the columns in my report.

       

       

      I suspect this has something to do with either me using Tabular Editor.

      • oakgogo's avatar
        oakgogo
        Helper II
        2 years ago

        Hi, I met the same issue. you can try this one: