Defined Measure help: Hours logged, not in sprint

I’m trying to create a calculated measure for issues with hours spent, but were not listed in the Sprint selected in the current page. Any help would be greatly appreciated.

This doesn’t work, but I’m trying:

[Measures].[Hours spent]
WHEN
Aggregate(
Filter([Sprint].[Sprint].Members,
[Sprint].CurrentMember.Name <> “(no sprint)”
AND
NOT [Sprint].CurrentMember.GetBoolean(“Closed”))))

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