Issues with Remaining estimated hours

Questions & Answers
1

Hi,

I need to show the number of tasks with Remaining estimates set for a Sprint.
I try hard to get the below measure working but it crashes the report with ‘Out of memory’ every time I run it.
Pages: Sprint, Issue Type (to filter only tasks)
Rows: Sprint (current one select)

Sum(
    Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    NOT IsEmpty([Measures].[Remaining estimated hours])), 
    [Measures].[Issues created]
  )

In fact, I need the same measure as ‘Issues with Original estimated hours’ but for remaining aka ‘Issues with Remaining estimated hours’

Can someone please help?

2

Hi @MikeS,

The OutOfMemory error is caused due to iteration through all issues in the data cube for each sprint.
The solution to that problem is to reduce the dataset for iteration by pre-filtering only the projects relevant to the displayed sprint.

You might try using the following expression.

Sum(
 Filter(
   Generate(
--filter relevant projects     
    Filter(
      DescendantsSet(
        [Project].CurrentMember,
        [Project].[Project]),
--conditon for project - issues belong to sprint
      [Measures].[Issues created]>0
      ), 
-- set of issues within the project  
   Descendants(
    [Issue].[Project].GetMemberByKey(
      [Project].CurrentMember.Key),
    [Issue].[Issue])
   ),
--filter condition for issue - belongs to sprint
  [Measures].[Issues created]>0),
--numeric value for Sum  
--secondary condition on reduced dataset
   CASE WHEN
    [Measures].[Remaining estimated hours]>0
   THEN
    1
   END
)

Regards,
Oskars / support@eazyBI.com