Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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]))))
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.