Forum Discussion
Narendra
Microsoft Employee
Microsoft EmployeeColumn 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...
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
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"
This is the answer!!! Thank you!!!!!!!!!