Cannot calculate total of a column

[saipawar]

Hi, I have a tabke with column Goals (Whole Number). However, when I add this column to a table, I don't seem to get the total at the bottom of the table

[v-easonf-msft]

Hi, @saipawar 

Could you please tell me whether your problem has been solved?
For now, there is no content of description in the thread. If you still need help, please share more details to us.

Also,please check whether the field 'team' in your table vuisual belongs to the table "Collab HC Gobals" rather than table 'Collab Headcount'.

Best Regards,
Community Support Team _ Eason

[PaulDBrown]

@saipawar 

Use a measure instead of the column:

Sum of Goals = SUM(Table[Goal])

or change the "Summarization" to "Sum"

[saipawar]

Both did not work! 
The measure degrouped each team name and the second method added the total on each line.

[PaulDBrown]

@saipawar 

In that case, can you please show your model layout and how you are creating the visual? (A simple sum measure should not be affecting any groupings).

or, share a sample PBIX file or dataset

[saipawar]

Here's a screen grab of my model. I hope this helps.

[PaulDBrown]

@saipawar 

So the measure should be:

Sum of Goals = SUM(Collab HC Goals)

How are you creating the visual? what fields and from which table?

[amitchandak]

@saipawar , Name of the column in the below screenshot is different. Is it renamed at the visual level?

Check Aggregation at the visual level, Right-click on the column in the visual pane and check

[saipawar]

@amitchandak the column is renamed at Visual level. However, on right clicking the column, I see no option