Forum Discussion
My report suddenly do not show aggregation in visualization although it used to show before?
Hello everyone,
I have a report working this month, and it works normally with the aggregation in visualization.
But suddenly, it stop aggregating like sum or show min, max values. I don't know if I accidentally changed anything. I see that the Summarization on the ribbon still show Sum, but in the visual it doesn't. I am trying to figure it out but can not find any same problem in the forums. I hope someone can help me with this and I am appreciate so much.
I have uploaded some photos for you to describe my problem. Hope this will help you guys imagine.
Thank you.
This is the visual I did before, in the same report. It works normallyThis is the same report with another visual I create recently, it doesn't work as it has to.The summarization still show Sum, but it shows distinct values instead.
2 Replies
- Idrissshatila
Super User
What you could do is that you create a new measure as the following
Total Emission = Sum(emission)
and you can add it to the visuals you want.
If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos đź‘Ť
Hello, sorry for my late responding. I tried that too, it seems the only way for me to temporary fix that problem. However, I want to fix that from the root because I have so many columns to create measure each time I want a simple visual that at the first time it doesn't need to. It seems like not the efficient way to do. I'm still try figuring it out. I am appreciate so much for your help. If you know another way, please just let me know. Again, thank you so much.
