Forum Discussion
Default Summarization Not Working
Hi guys,
I'm having a problem using default summarization. My model has 3 tables, d calendar, d fb ads and fb ads.
I've established the following relationship between then:
I've setted default summarization for 'f fb_ads' [spend] as SUM as well as for 'f fb_ads' [impressions]. The columns 'f fb_ads[spend] is setted as fixed decimal number, and 'f fb_ads' [impressions] is an integer.
When try to create a table visual, using the columns: 'd calendar'[date] and 'f fb_ads' [spend], the default summarization does not work.
And, if I would like to see the sum of spend for a specific day, I need to create a simple measure, like :
I've already check if all date's columns are settled as date type. Anyone know what might be the problem ?
- d calendar:
- f fb_ads
14 Replies
Anonymous , right on the field in the visualization tab. And check what is summarization.
1. If default summarization is changed after its was dragged into a visual, that visual will not use default summarization .
2. Also if summarization is changed on visual it will not pick up deafult summarization
3. remove the column and add again and check
amitchandak Thank for your reply.
Unfortunately the problem is still occorring. I was not able to find the Summarization option inside the Visualizations Menu. I remember that in previous versions of PBI Destktop it used to have this option, but, as I'm using the last version of PBI Desktop, I didn't find the option.
I've checked the 'f fb_ads'[spend] data type using Fields Menu, and it's setted to SUM.
Hi Anonymous ,
I can't reproduce your problem. What's the version of your Power BI Desktop? In addition to not being able to use the default summarization function, the menu options in your screenshot are also different from mine: it does not contain any aggregation function options. It is strange... Could you please try to create another visual used another numeric field and check whether the default summarization function can work or not?
Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.
Hi Community,
In my case this topic seem to occur due to the I created in the past a Calculation Group (I do not know if you need it, but I delete it because we just use for test propuses). Hence to solve this I did the following:
1- Delete the Calculation Group
2- Go to External Tool --> Tabular Editor
3- Within Tabular Editor By Clicking on Model (top-left) --> On bottom-right Change "Discourage Implicit Measures" to False --> Go to File + Save
4- Save your PBI file and restart
5- Then should work
I am having the same issue with default summarization on the latest May 2021 build. Redoing the file from scratch fixes the issue. Did the latest build have a change in a global setting that interferes with default summarization? When a column has Summarization: Sum chosen on Data/Column tools, I would expect to see a Greek Sigma sign next to the field in the field summary, and have it be able to be used as a sum in visuals instead of a row or column header
Anonymous This is a known bug we have encountered several times where values fail to get recognized as values even though they are shown as such. The only solution I know of is to do an additional column in DAX like this: Go To the Data area / Table Tools (on menu bar) / Add Column. Add column of VALUE ([column name that isnt summing]). That column will then auto sum.
