March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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.)
thanks for your help..
Solved! Go to 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]))))
@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]))))
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
94 | |
92 | |
91 | |
79 | |
49 |
User | Count |
---|---|
160 | |
144 | |
103 | |
72 | |
55 |