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
Greg_Deckler
Community Champion
Community ChampionNot sure I understand, but you should just be able to right click the headings and rename them.