Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Summarization issue

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

Need Help

3 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    5 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    HI Anonymous,

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

    Regards,
    Xiaoxin Sheng