Forum Discussion
Microsoft EmployeeSummarization (Don't Summarize) should turn OFF by Default
By default numeric columns are 'summarized with Sum'. This should be reversed so that no columns are summarized or just limited to Currency columns only. This is because the majority of the columns in most tables (dimensions and fact tables) are not summarizable but for display purpose only. I realized that the PowerBI desktop is smart enough not to summarize the columns participating in relationships (foreign keys) but there are other numeric columns that are like flags (integer with more than 2 values) that are marked as summarized and it takes a long time to go through all tables (including the dates table) to change the SUMMARIZATION to DON'T SUMMARIZE.
the benefit to making DON'T SUMMARIZE as a default option is that we will save a lot of time enhancing the model.
all we need then is to go change a small number of columns we want to summarize to appropriate aggregation function given that currency values are already marked as SUMMARIZED.
thanks guys, great work.
Hi，
It is by default in power bi. And you can change the summary way of them by multiple select these columns through the 'CRTL' key.
As a workaround, you can also use aggregations in Power BI Desktop. Please refer to https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-aggregations
Best Regards,
Dedmon Dai
6 Replies
- Greg_Deckler
Community Champion
binhcao - You would want to post this to the Ideas forum, https://aka.ms/PBI_Comm_Ideas
You can set the default summarization for columns under Column tools in the ribbon but I realize that is a pain sometimes. I would support this idea if it was made to be an option under Report settings. There you could choose the default summarization for numeric columns imported into the model and choose Sum, Average, Min, Max, none, etc.
v-deddai1-msftCommunity Support
Hi，
It is by default in power bi. And you can change the summary way of them by multiple select these columns through the 'CRTL' key.
As a workaround, you can also use aggregations in Power BI Desktop. Please refer to https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-aggregations
Best Regards,
Dedmon Dai
This "fix" does not work in my version. Granted I am just learning Power BI but this auto setting for different 20 columns in my 6 data sources is a glitch in how wonderful this program is supposed to be. It is MUCH simpler to change columns or multiple columns in Excel. The Ctrl key +click doesn't do anything in my version. I had to change every column one at a time. I have been able to test if I am going to have to do this every time I refresh these tables. This need to be corrected.
Agreed. Numeric columns should come in as "don't summarize" by default. Or at least allow the user to set the default Summarization should the current default not meet their business needs.
2026 answer.
With new power bi project file format. (If you save your pbix file to pibp)
Your power bi file now is distributed into parts.
Go to folder: ?your_power_bi_file_name?.SemanticModel/defintion/tables, and you will find all the tmdl files. These are your table definitions. Open a file and you will able to find each column and their `summarizeBy`
`summarizeBy = .....(count, sum, ect...)` this is the attribute that you want to update.
The trick here is how to change them all at once. I am able to do this via Search and replace all with help of regular expression on in vs code.
Just open the folder in vs code, and find and replace this from`summarizeBy = count` --> `summarizeBy = none`
In Search with regex* (make sure highlighted/on where red arrow is pointing at)
find them all using --> summarizeBy:\s*(Sum|Average|Count|Min|Max|DistinctCount)
replace with string --> summarizeBy : none
** You might need to re-open your powerbi file to take effect. **
Bonus: why not as your AI to replace it all for you.
