# Count issues with remaining hours

Hello,
I would like to display the number of issues with remaining hours.
The predefined measure “Remaining estimated hours” works well but i would like to add a calculated measure which show the number of issues considered by the predefined measure “remaining estimated hours”
Is there a solution?
Best regards

i have performed this formula.
it seems to work:
is it correct? is there a better way?

Sum(
Filter(
Descendants([Issue].CurrentMember,[Issue].[Issue]),
DateInPeriod(
[Issue].CurrentMember.GetDate(‘Release Date’),
[Time].CurrentHierarchyMember
)
),
CASE WHEN
[Measures].[Remaining estimated hours]>0
THEN 1
ELSE 0
END
)

@clement_dd_64
Your formula is correct, and there is no better way than iterating through “Issue” dimension to find the count of issues with remaining estimated hours grouped by Release dates.
I would recommend a slightly smarter version of formula which would work faster, if just one project is selected from the “Project” dimension page filter:

``````CASE WHEN
[Project].Currenthierarchymember.level.name = "Project"
THEN
Sum(
Filter(
Descendants([Issue].[Project].GetMemberbyKey([Project].CurrentMember.KEY),[Issue].[Issue]),
DateInPeriod(
[Issue].CurrentMember.GetDate('Release Date'),
[Time].CurrentHierarchyMember
)
),
CASE WHEN
[Measures].[Remaining estimated hours]>0
THEN 1
ELSE 0
END
)
ELSE
Sum(
Filter(
Descendants([Issue].CurrentMember,[Issue].[Issue]),
DateInPeriod(
[Issue].CurrentMember.GetDate('Release Date'),
[Time].CurrentHierarchyMember
)
),
CASE WHEN
[Measures].[Remaining estimated hours]>0
THEN 1
ELSE 0
END
)
END
``````

Martins