how to get a total on a % column to reflect total % of the group selected

[electrobrit]

I am stumped on what I could do differently to get the totals to do the calculations of the group vs just working for the individual. (I don't even have the option to  do an average of the group selected.)

Sample pbix 

thanks for your help..

[amitchandak · Accepted solution]

@electrobrit , You can get avg like

Gross Billable % = 
AVERAGEX(values(TimeDetail[full_name]), CALCULATE( IF(SELECTEDVALUE(
TimeDetail[full_name]) IN  {"EmployeeB", "EmployeeD"},
[Net Billable %],
           CALCULATE([Billable Hours]/[PeriodWorkingHours]))))