Forum Discussion
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?
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
9 Replies
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 CommunityRafalK you will have to check the data type in power query as well the data type in power query and power destop should match
Hi RafalK ,
It is worth noting that the Summarization works when it’s used in a visual.
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.
