Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team,
I have a measure "Project Aux" created as below and formated as hh:nn:ss. However, this doesnt show accurate total for the hierarchy. In the below picture, I need the total to be total hours/min/sec of the ones marked in yellow.
How do I amend the below measure to get the right total? please help.
Solved! Go to Solution.
You've got some errors in your computations.
I'd suggest something similar to the post I linked:
Duration Formatted =
VAR TotalDuration = SUM ( ITOps_Telecom[Aux6] )
VAR TotalHours = TRUNC ( 24 * TotalDuration )
VAR MinSec = FORMAT ( TotalDuration - TotalHours / 24, "nn:ss" )
RETURN
TotalHours & ":" & MinSec
@AlexisOlson I modified your solution and it worked. My duration is in Seconds. So I divided sum(itops_telecom[aux6) by 86400 which is 24*60*60.
thank you very much
I don't think the time data type supports values greater than 24 hours, so you'll need to change this to return text values in the format you prefer.
See here for formatting suggestions: https://stackoverflow.com/questions/50388603
@AlexisOlson Thank you for the response. I did try the below. but its not showing up the right value.
You've got some errors in your computations.
I'd suggest something similar to the post I linked:
Duration Formatted =
VAR TotalDuration = SUM ( ITOps_Telecom[Aux6] )
VAR TotalHours = TRUNC ( 24 * TotalDuration )
VAR MinSec = FORMAT ( TotalDuration - TotalHours / 24, "nn:ss" )
RETURN
TotalHours & ":" & MinSec
@AlexisOlson I modified your solution and it worked. My duration is in Seconds. So I divided sum(itops_telecom[aux6) by 86400 which is 24*60*60.
thank you very much
Great. That's exactly what I was going to suggest since my TotalDuration assumed units of days.
User | Count |
---|---|
93 | |
83 | |
77 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |