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 , 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