Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]))))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
74 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |