Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I created a measure which calculates a percentage utilization. The measure is below:
Utilization Percent = (
SUM('Resource Utilization'[Billable Hours])
/
(
IF(
CALCULATE( SUM('Resource Utilization'[Work Week Hours]) ) = BLANK(),
0,
CALCULATE( SUM('Resource Utilization'[Work Week Hours]) )
) -
IF(
CALCULATE( SUM('Resource Utilization'[Time off Hours]) ) = BLANK(),
0,
CALCULATE ( SUM('Resource Utilization'[Time off Hours]) )
) -
IF(
CALCULATE( SUM('Resource Utilization'[Holiday Hours]) ) = BLANK(),
0,
CALCULATE ( SUM('Resource Utilization'[Holiday Hours]) )
)
)
) * 100
I want to create another measure, which calculates the sum of the above measure. I was wondering is there a way to create this measure? I tried a few scenarios with SUM and SUMX, but I either get an incorrect SUM amount or I get a syntax error.
Jason
Solved! Go to Solution.
Hi @ryan_mayu ,
I was able to figure out how to do this. What I did is the following:
Sum Utilization = SUMX(VALUES('Resource Utilization'[Id]), [Utilization Percent])
It seems to work.
Jason
could you pls provide the sample data and expected output?
Proud to be a Super User!
Hi @ryan_mayu ,
I was able to figure out how to do this. What I did is the following:
Sum Utilization = SUMX(VALUES('Resource Utilization'[Id]), [Utilization Percent])
It seems to work.
Jason
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |