Forum Discussion

Narendra's avatar
Narendra
Microsoft Employee
10 years ago
Solved

Column Names contains prefix as Sum Of

Hi All,   I have taken table as a  visualization in my Power Bi Desktop file. In this table I required total for all value fields , for this I have selected all value columns type as Sum but in thi...
Need Help
  • djnww's avatar
    djnww
    10 years ago

    Hi Narenda,

     

    The 'Sum of' will occur when you apply an aggregation which is different to the field/column's 'Default Summarization'.

     

    What you need to do is go to the Modelling tab, select the column in question, then change the 'Default Summarisation' to 'Sum'. Now go back to the report design and re-create the table from scratch. The 'Sum of' will no longer appear.

     

    Regards,

    Dan

djnww's avatar
djnww
Impactful Individual
10 years ago

Hi Narenda,

 

The 'Sum of' will occur when you apply an aggregation which is different to the field/column's 'Default Summarization'.

 

What you need to do is go to the Modelling tab, select the column in question, then change the 'Default Summarisation' to 'Sum'. Now go back to the report design and re-create the table from scratch. The 'Sum of' will no longer appear.

 

Regards,

Dan

Anonymous's avatar
Anonymous
Not applicable
3 years ago

This worked for me...

File | Options and Settings | Options | Current File | Report settings | Default summarizations | UNCHECK "For aggregated fields, always show the default summarization type"

  • kiriyandrey's avatar
    kiriyandrey
    New Member
    3 years ago

    It's a solution!!!

    Thank You.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    YES! This worked, Thank you

  • Smithtastic's avatar
    Smithtastic
    New Member
    2 years ago

    This is the answer!!! Thank you!!!!!!!!!