# Getting issues related to the current row

**URL:** <https://community.eazybi.com/t/getting-issues-related-to-the-current-row/74>\
**Category:** Questions & Answers\
**Created:** [June 9, 2017, 9:43am UTC](https://community.eazybi.com/t/getting-issues-related-to-the-current-row/74 "2017-06-09T09:43:24Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Stefan](https://community.eazybi.com/user_avatar/community.eazybi.com/stefan/32/33_2.png) [@Stefan](https://community.eazybi.com/u/Stefan)\
**Post date:** [June 9, 2017, 9:43am UTC](https://community.eazybi.com/t/getting-issues-related-to-the-current-row/74/1 "2017-06-09T09:43:24Z")

</div>

In many reports we looking for a sum/count or other calculation based on the issues related to the rows. What is the easiest method of getting these issues in a calculated member?

**Example** ;

As row, we selected ‘Fix Version’ and as column ‘measures’ and ‘segment’. Segments are in this case, B2C or B2B. (based on a multiple select field)

In the overview, we want to sum story points per segment, based on Fix Version. When an issue is for both segments, the total of story points should be divided by the selected segments.

 ![](https://community.eazybi.com/uploads/default/original/1X/9f0905d064ff363a75729a9156e8171cc9e230a8.png)

What is the preferred method of getting the issues for that row? My current filter looks like this, but I’m sure there is a better way 😉

```
filter(
      Descendants([Issue].CurrentMember, [Issue].[Issue]),
      [Measures].[Issues resolved] > 0 AND
      [Measures].[Story Points] > 0       
 )

```

Cheers,  
Stefan

---

<div class="post-metadata">

**Author:** ![raimonds.simanovskis](https://community.eazybi.com/user_avatar/community.eazybi.com/raimonds.simanovskis/32/15_2.png) [@raimonds.simanovskis](https://community.eazybi.com/u/raimonds.simanovskis)\
**Post date:** [June 10, 2017, 9:12am UTC](https://community.eazybi.com/t/getting-issues-related-to-the-current-row/74/2 "2017-06-10T09:12:09Z")

</div>

It is always better (faster) to avoid iterating over issues at the detailed Issue level.

In this case, I would recommend creating a calculated JavaScript field which during the import would calculate adjusted Story Points as (Story Points value) / (count of segments). And then you could use this precalculated adjusted story points measure in the report.

---

<div class="post-metadata">

**Author:** ![fabian.lim](https://community.eazybi.com/letter_avatar_proxy/v4/letter/f/0ea827/32.png) [@fabian.lim](https://community.eazybi.com/u/fabian.lim)\
**Post date:** [October 12, 2018, 3:20pm UTC](https://community.eazybi.com/t/getting-issues-related-to-the-current-row/74/3 "2018-10-12T15:20:11Z")

</div>

Hi Raimonds,

Do you have an example on how we ca go through all the project issues in the javascript code during the import?

I went through the following documentation: [https://docs.eazybi.com/eazybijira/data-import/custom-fields/javascript-calculated-custom-fields](https://docs.eazybi.com/eazybijira/data-import/custom-fields/javascript-calculated-custom-fields) b, but I don’t see a way to iterate through all the issues in a project. The closest example is the one where it goes through the linkedissues.

Regards,

Fabian

---

<div class="post-metadata">

**Author:** ![raimonds.simanovskis](https://community.eazybi.com/user_avatar/community.eazybi.com/raimonds.simanovskis/32/15_2.png) [@raimonds.simanovskis](https://community.eazybi.com/u/raimonds.simanovskis)\
**Post date:** [October 12, 2018, 4:07pm UTC](https://community.eazybi.com/t/getting-issues-related-to-the-current-row/74/4 "2018-10-12T16:07:05Z")

</div>

Typically there is no need to iterate through all issues in the custom JavaScript code – you just pre-calculate some additional measures or properties for an individual issue and then it can be aggregated later in eazyBI reports.

If you could describe what is your business need then we could point you to a similar example.

---

<div class="post-metadata">

**Author:** ![fabian.lim](https://community.eazybi.com/letter_avatar_proxy/v4/letter/f/0ea827/32.png) [@fabian.lim](https://community.eazybi.com/u/fabian.lim)\
**Post date:** [October 12, 2018, 4:25pm UTC](https://community.eazybi.com/t/getting-issues-related-to-the-current-row/74/5 "2018-10-12T16:25:20Z")

</div>

My Question is in this post: [Count number of times a test case has been mentioned in other tickets](https://community.eazybi.com/t/count-number-of-times-a-test-case-has-been-mentioned-in-other-tickets/1122)