# Number of stories under Initiative **URL:** \ **Category:** Questions & Answers\ **Tags:** calculatedmembers, mdx\ **Created:** [May 7, 2025, 2:00pm UTC](https://community.eazybi.com/t/number-of-stories-under-initiative/19956 "2025-05-07T14:00:19Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![mctaggartm](https://community.eazybi.com/letter_avatar_proxy/v4/letter/m/9fc29f/32.png) [@mctaggartm](https://community.eazybi.com/u/mctaggartm)\ **Post date:** [May 7, 2025, 2:00pm UTC](https://community.eazybi.com/t/number-of-stories-under-initiative/19956/1 "2025-05-07T14:00:19Z")
Hi, I have a structure in Jira that is Agile Initiative → Epic → Story. What MDX do i use in a calculated measure to return the number of stories within a specific Agile Initiative with status ‘Ready for Development’? Thanks, Mark ---
**Author:** ![Elita.Kalane](https://community.eazybi.com/user_avatar/community.eazybi.com/elita.kalane/32/14957_2.png) [@Elita.Kalane](https://community.eazybi.com/u/Elita.Kalane)\ **Post date:** [May 20, 2025, 4:30pm UTC](https://community.eazybi.com/t/number-of-stories-under-initiative/19956/2 "2025-05-20T16:30:13Z")
Hi @mctaggartm Welcome to eazyBI Community! If your hierarchy is implemented using Plans (formerly Advanced Roadmaps), you might consider using issue link field dimensions to filter stories by their parent initiative’s properties. See here how you can import the Plans hierarchy - [Plans custom fields](https://docs.eazybi.com/eazybi/data-import/data-from-jira/plans-custom-fields) Once that is imported, you can update eazyBI settings ([Advanced settings for custom fields](https://docs.eazybi.com/eazybi/data-import/data-from-jira/jira-custom-fields/advanced-settings-for-custom-fields)) with the code as given in the example in this documentation (Initiative status) - [Issue link field dimensions](https://docs.eazybi.com/eazybi/data-import/data-from-jira/advanced-data-import-options/issue-link-field-dimensions#Issuelinkfielddimensions-InitiativeStatus) After importing this dimension, you could then use it in your reports to filter stories based on their parent initiative’s status. Let me know if this works for your specific setup, if you get stuck with any of the steps or if you have some follow up questions! Best wishes, Elita from [support@eazybi.com](mailto:support@eazybi.com) ---
**Author:** ![mctaggartm](https://community.eazybi.com/letter_avatar_proxy/v4/letter/m/9fc29f/32.png) [@mctaggartm](https://community.eazybi.com/u/mctaggartm)\ **Post date:** [May 21, 2025, 8:51am UTC](https://community.eazybi.com/t/number-of-stories-under-initiative/19956/3 "2025-05-21T08:51:40Z")
> [@Elita.Kalane](#): > > could then us Hi Elita, thanks for the response. I want to return the number of stories that have the status ‘Ready for Development’ that are under a specific initiative. I am not worries about the initiative status. Is it possible to do this within a custom measure? Thanks ---
**Author:** ![Elita.Kalane](https://community.eazybi.com/user_avatar/community.eazybi.com/elita.kalane/32/14957_2.png) [@Elita.Kalane](https://community.eazybi.com/u/Elita.Kalane)\ **Post date:** [May 23, 2025, 7:35am UTC](https://community.eazybi.com/t/number-of-stories-under-initiative/19956/4 "2025-05-23T07:35:13Z")
Hi @mctaggartm Thanks for the follow-up! In that case you may want to define a new calculated measure in the Measures dimension using the Tuple function ([Tuple](https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/tuple)) that will count the stories created under your Initiative where the Story status is Ready for Development. ```auto ( [Measures].[Issues created], [Issue Type].[Story], [Status].[Ready for Development] ) ``` See example in the screenshot below how it may look. ![image](https://community.eazybi.com/uploads/default/original/2X/c/c96f7ffe9e58e8d3963bd299a3c3e16b8eaecf35.png) Best wishes, Elita from [support@eazybi.com](mailto:support@eazybi.com) ---
**Author:** ![mctaggartm](https://community.eazybi.com/letter_avatar_proxy/v4/letter/m/9fc29f/32.png) [@mctaggartm](https://community.eazybi.com/u/mctaggartm)\ **Post date:** [May 23, 2025, 3:14pm UTC](https://community.eazybi.com/t/number-of-stories-under-initiative/19956/5 "2025-05-23T15:14:20Z")
> [@Elita.Kalane](#): > > new calculated measure in the Measures dimension using the Tuple function ([Tuple](https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/tuple)) that will count Thanks for the reply. Is it possible to specify the initiative within the measure itself? I want to have projects/teams in rows whereas you have themes in rows (above). ---
**Author:** ![Elita.Kalane](https://community.eazybi.com/user_avatar/community.eazybi.com/elita.kalane/32/14957_2.png) [@Elita.Kalane](https://community.eazybi.com/u/Elita.Kalane)\ **Post date:** [May 25, 2025, 8:15am UTC](https://community.eazybi.com/t/number-of-stories-under-initiative/19956/6 "2025-05-25T08:15:53Z")
Hello @mctaggartm Thanks for the clarification! In that case, add another line in the Tuple function where you refer to this specific Initiative. If you are using the Plans hierarchy and have imported the Parent link, the dimension should come up similarly as this (in my case Plans Theme): ```auto ( [Measures].[Issues created], [Issue Type].[Story], [Status].[Done], [Plans Theme].[ETQ-349] ) ``` ![image](https://community.eazybi.com/uploads/default/original/2X/c/c59aafee18ba640e804ee6e26c6a888d9b8f56e1.png) Best wishes, Elita from [support@eazybi.com](mailto:support@eazybi.com) ---
**Author:** ![mctaggartm](https://community.eazybi.com/letter_avatar_proxy/v4/letter/m/9fc29f/32.png) [@mctaggartm](https://community.eazybi.com/u/mctaggartm)\ **Post date:** [May 30, 2025, 9:02am UTC](https://community.eazybi.com/t/number-of-stories-under-initiative/19956/7 "2025-05-30T09:02:10Z")
Thanks Elita this solution worked well