# Create Future sprints Calculated members in Sprint dimension Week cycle hierarchy

**URL:** <https://community.eazybi.com/t/create-future-sprints-calculated-members-in-sprint-dimension-week-cycle-hierarchy/13018>\
**Category:** Questions & Answers\
**Tags:** calculatedmembers, sprint\
**Created:** [June 26, 2023, 1:31pm UTC](https://community.eazybi.com/t/create-future-sprints-calculated-members-in-sprint-dimension-week-cycle-hierarchy/13018 "2023-06-26T13:31:53Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![silvijar](https://community.eazybi.com/letter_avatar_proxy/v4/letter/s/edb3f5/32.png) [@silvijar](https://community.eazybi.com/u/silvijar)\
**Post date:** [June 26, 2023, 1:31pm UTC](https://community.eazybi.com/t/create-future-sprints-calculated-members-in-sprint-dimension-week-cycle-hierarchy/13018/1 "2023-06-26T13:31:53Z")

</div>

Hello,

I’m trying to create Future sprints calculated member in Week cycles property which I created following [Sprint reports for sprint week cycles (Sprint custom hierarchies) (eazybi.com)](https://docs.eazybi.com/eazybi/learn-more/learn-eazybi-through-examples/sprint-reports-for-sprint-week-cycles-sprint-custom-hierarchies) documentation.

At the moment I have no success in writing a calculated member for future sprints - my goal is to only show week cycles where future sprints exists.

Any ideas how to do this?

---

<div class="post-metadata">

**Author:** ![roberts.cacus](https://community.eazybi.com/user_avatar/community.eazybi.com/roberts.cacus/32/637_2.png) [@roberts.cacus](https://community.eazybi.com/u/roberts.cacus)\
**Post date:** [July 5, 2023, 9:42am UTC](https://community.eazybi.com/t/create-future-sprints-calculated-members-in-sprint-dimension-week-cycle-hierarchy/13018/2 "2023-07-05T09:42:06Z")

</div>

Hi @silvijar ,

The _Sprint_ dimension calculated member needs to consider the “Week cycle” members and their children, the Sprints, to return only those cycles with future Sprints. The calculated measure in the default hierarchy, returning “Boards” with future Sprints, could look similar to the one below:

```auto
Aggregate(
  Filter(
  [Sprint].[Board].Members,
  Filter(
    ChildrenSet([Sprint].CurrentHierarchyMember),
    [Sprint].CurrentHierarchyMember.Get('Status') = 'Future'
  ).Count > 0
  )
)

```

Try to adapt it to fit your custom hierarchy and select the correct hierarchy for the calculated member.

 ![Screenshot 2023-07-05 at 12.38.22](https://community.eazybi.com/uploads/default/original/2X/e/e4a2e18c7322807a16e359789f1a0c6fe0d5ed93.png)  
See a screenshot of the expected result below.  
 ![Screenshot 2023-07-05 at 12.40.30](https://community.eazybi.com/uploads/default/original/2X/c/c4d2c37b7569c273a2cc2262482f555012e23b63.png)

Please look at our documentation page for more information on defining calculated measures - ​[Calculated measures and members](https://docs.eazybi.com/eazybijira/analyze-and-visualize/calculated-measures-and-members).

Best,  
Roberts // [support@eazybi.com](mailto:support@eazybi.com)