Forum Discussion
Microsoft EmployeeColumn Names contains prefix as Sum Of
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
Community ChampionNarendra If I understand what you are trying to do is sum those columns but not say Sum of in the name?
go to the Modeling tab and create a New Measure with whatever name you choose
Total Asset Count = SUM(TableName[Asset Count])
and then use this Measure in your table
let me know if this is what you are trying to do?
Microsoft EmployeeHi Sean,
May i know why few fileds are not containts any prefix sum of and few fields are contains prefix as sum of. If i have to do like that then i have to create so many measures in my pbix file. In above screen shot few columns does not have prefix sum of but few columns prefix sum of.