Forum Discussion
Default Summarization Not Working
Hi Anonymous ,
Yes, you can mark your post as Answered if the problem has been resolved.
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 Anonymous ,
Sorry I can't reproduce your problem... Could you please try to upgrade the version of your Power BI Desktop to the latest one? Besides that, please try to create a new report file and make a table with below data. Then create a table visual using value field and check whether you can get the aggregation options normally...
| ID | Value |
| id1 | 1 |
| id2 | 2 |
| id3 | 4 |
| id4 | 3 |
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 Anonymous , how are you doing ?
Over the weekend I've made some test in order to understand better the problem.
First I created the table that you suggested inside the current PBI File that I was working on. The problem still happening, and the Value was not summarized. I think that PBI was interpreting Values column as a String.
Then I've created a new PBI File and insert your suggestion table in it. The problem did not reappear and everything returned to normal.
After validating the issue didn't occours again, I've imported all my tables from my MYSQL database, and the default summarization started to work again. So I'm creating all my model from scratch, and fortunately, the problem is not occuring.
In all the tests I was working with the same PBI Version: 2.87.762.0 64-bit (novembro de 2020).
Thank for your time and help. Should I mark your last comment as a solution ?
Best Regards,
I've had this exact same problem, all the tables in my data model were like this.
However, if I create a brand new PBIX file everything is fine.
Is the only solution to recreate the entire PBIX file? It looks like the file has corrupted somehow. Ideally I don't want to have to recreate my PBIX file.
Is there a global setting that affects the global summarizations?
Thanks
Hi Anonymous ,
Yes, you can mark your post as Answered if the problem has been resolved.
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.I am having the same issue and I can not recreate the whole report. Please let me know if there is any other resolution for this issue.
I added a answer on top, it might help to you
