Defined Measure help: Hours logged, not in sprint

Questions & Answers
2

Measure Hours spent should show logged time while the issue was added to the sprint.

  1. The issue might have more logged time in total, though. If you would like to count total logged time for completed issues in a sprint, no matter when the time was logged on issue you can use this formula:

     CASE WHEN
     [Sprint].Currentmember.Level.name = "Sprint"
 THEN
   NonZero(SUM(
     Filter(
       Descendants([Issue].Currentmember, [Issue].[Issue]),
        CoalesceEmpty([Issue].CurrentMember.Get("Sprint IDs"),
          CoalesceEmpty([Measures].[Issue Sprint], "")
        ) MATCHES ".*"|| Cast([Sprint].CurrentMember.Key as string) ||".*"
       ),
       CASE WHEN
       ([Measures].[transitions to], [Sprint Status].[Active]) > 0
       THEN
          val(([Measures].[Hours spent],
          [Sprint]. DefaultMember))
       END
   ))
 END

  2. If you would like to count total time logged in any issue during active sprint cycle (no matter if the time was logged in sprint or outside of sprint parallel to sprint cycle), you can check out this community topic:
    Linking Non-Sprint Work to Sprint Based on Logged By and Date

Daina / support@eazybi.com