Summarization issue

[Anonymous]

Hi,

I have some issue with PBI aggregarion and I have no idea why it behaves this way. I have few columns which should be aggregated, but I cannot forced them to sum up. I've already checked if data type is a number and summarization option is set up for "Sum". In "Model" view, my columns are marked with sigma sign, but when change view to "Data" or "Report" - then the sigma dissapears and I cannot aggregate them. I know, that it may happend, when calculated groups are being implemented, but I don't have this solution in my report. I use the newest version of PBI Desktop (April 2021).

Do you have any idea, what can I do? Please help

NKM

[Anonymous]

HI @Anonymous,

Any update or detailed information about your scenario to help us clarify your scenario?

Regards,
Xiaoxin Sheng

[Anonymous]

Hi @Anonymous,

Can you please share a pbix file with some dummy data? It should help us clarify your scenario and test to troubleshooting.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[PaulDBrown]

@Anonymous 

It is highly recommended that you use explicit measures instead of default aggregations or implicit measures. So for a sum, create a measure along the lines of:
Sum of values = SUM(Table[Column of values])

And use the measure in the visuals.