Total a column of Averages

[GTL]

Hi everyone!

I have created a table that is pulling from a database linked through an API. This question is regarding the average headcount column. I would like the total at the bottom to be a sum of the rows, not an average of the rows. Therefore, instead of it saying 9.10, it should say 45.67.

The formula feeding this column is: Average Headcount = average('Forms-Work logs'[headcount])

I am satisfied with the whole table except for the 9.10. Could someone please tell me how to switch that over to total instead of average. Thank you!

[GTL]

@tamerj1 

[tamerj1]

Hi @GTL 

what are you slicing by in this table?

[GTL]

Project name and then each row represents a different company that worked on the project that given day or over a period of days. I have another slicer in there to select date ranges.

[tamerj1 · Accepted solution]

@GTL 

Please try

Average Headcount =
SUMX (
SUMMARIZE (
'Forms-Work logs',
'Forms-Work logs'[Project Name],
'Forms-Work logs'[Company Name]
),
CALCULATE ( AVERAGE ( 'Forms-Work logs'[headcount] ) )
)

[GTL]

That did it! I cannot thank you enough @tamerj1! Have a great day!