Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
RafalK
Advocate IV
Advocate IV

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 table.

 

Perhaps this has something to do with me using Tabular Editor Tool?

 

RafalK_0-1601992895837.png

 

Rafał Kun
1 ACCEPTED SOLUTION
RafalK
Advocate IV
Advocate IV

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

Rafał Kun

View solution in original post

9 REPLIES 9
RafalK
Advocate IV
Advocate IV

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

Rafał Kun
v-eqin-msft
Community Support
Community Support

Hi @RafalK ,

 

It is worth noting that the Summarization works when it’s used in a visual.

10.7.4.1.png

10.7.4.1.Columns-don-t-aggregate.gif

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.

If not, please upload some insensitive data samples and expected output.

 

Best Regards,

Eyelyn Qin

Hi - As noted before, this column is set to Sum however it does not act like one.

I can't drag and drop it to a visual - Power BI will not allow me.

This must be some bug. I will try to reconstruct the report and look for the problem in upcomming days.

 

Rafał Kun
Anonymous
Not applicable

@RafalK you will have to check the data type in power query as well the data type in power query and power destop should match

Anonymous
Not applicable

@RafalK  Also make sure that the below option is selected

sum.PNG

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

Rafał Kun
Anonymous
Not applicable

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

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.

RafalK_0-1601996608655.png

 

 

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

Rafał Kun

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

oakgogo_0-1701700469532.png

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.