"Sum of" in Column Header

[cwalsh]

I've put together a Table with data from a pivot table.  All columns are summed so I can apply conditional formatting, but the "ID" column is the only column that has "Sum of" in the header.  I cannot figure out why it is the only column with it or how to get it to go away.  If I change the value type (to Average, Count, etc.) of the other columns, then it adds the "(value type) of" in the column header.  Sum is the only selection that doesn't add text to the column header.  Something is off.

[Phil_Seamark · Accepted solution]

Have a crack at making your own measures. 

So rather than dragging your value across and setting the aggregation type.  Create a new measure like 

ID = SUM('Table'[Value])

and dragging this measure to your visual.

[cwalsh]

@Phil_Seamark  That worked!  Thank you!

[Phil_Seamark]

With this approach, your measure name becomes the column header.