Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to Solution.
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
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
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.
@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
Thanks but as you can see on my screenshot it is.
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.
I suspect this has something to do with either me using Tabular Editor.
Hi, I met the same issue. you can try this one:
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |