# How to get all issues whose Fix Versions is same as Affects version

**URL:** <https://community.eazybi.com/t/how-to-get-all-issues-whose-fix-versions-is-same-as-affects-version/5383>\
**Category:** Questions & Answers\
**Created:** [October 7, 2020, 9:49am UTC](https://community.eazybi.com/t/how-to-get-all-issues-whose-fix-versions-is-same-as-affects-version/5383 "2020-10-07T09:49:55Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![rahuldanwade](https://community.eazybi.com/user_avatar/community.eazybi.com/rahuldanwade/32/3498_2.png) [@rahuldanwade](https://community.eazybi.com/u/rahuldanwade)\
**Post date:** [October 7, 2020, 9:49am UTC](https://community.eazybi.com/t/how-to-get-all-issues-whose-fix-versions-is-same-as-affects-version/5383/1 "2020-10-07T09:49:55Z")

</div>

Tried below calculated measure but no luck

( [Measures].[Issues created],  
[Affects Version.By name].[Name].GetMemberByKey(  
[Fix Version].CurrentMember.Key  
)

---

<div class="post-metadata">

**Author:** ![janis.plume](https://community.eazybi.com/user_avatar/community.eazybi.com/janis.plume/32/8826_2.png) [@janis.plume](https://community.eazybi.com/u/janis.plume)\
**Post date:** [October 16, 2020, 8:29am UTC](https://community.eazybi.com/t/how-to-get-all-issues-whose-fix-versions-is-same-as-affects-version/5383/2 "2020-10-16T08:29:15Z")

</div>

Hi,

Your formula seems very close to the solution, assuming that you are using the Fix version dimension with the By Name hierarchy in your report. The function of **CurrentMember** by default uses the default hierarchy, which in your case is not used in the report. The **CurrentHierarchyMember** should fix that:

```
( [Measures].[Issues created],
[Affects Version.By name].[Name].GetMemberByKey(
[Fix Version].CurrentHierarchyMember.Key)

```

Kindly,  
Janis, eazyBI support

---

<div class="post-metadata">

**Author:** ![rahuldanwade](https://community.eazybi.com/user_avatar/community.eazybi.com/rahuldanwade/32/3498_2.png) [@rahuldanwade](https://community.eazybi.com/u/rahuldanwade)\
**Post date:** [November 6, 2020, 11:43am UTC](https://community.eazybi.com/t/how-to-get-all-issues-whose-fix-versions-is-same-as-affects-version/5383/3 "2020-11-06T11:43:02Z")

</div>

Thanks Janis. It works.

---

<div class="post-metadata">

**Author:** ![sraj](https://community.eazybi.com/user_avatar/community.eazybi.com/sraj/32/4517_2.png) [@sraj](https://community.eazybi.com/u/sraj)\
**Post date:** [March 26, 2021, 8:00pm UTC](https://community.eazybi.com/t/how-to-get-all-issues-whose-fix-versions-is-same-as-affects-version/5383/4 "2021-03-26T20:00:49Z")

</div>

![image](https://community.eazybi.com/uploads/default/original/2X/1/1a5fe29cc9acf0fdb03091ef4981ee0e6c4118d3.png)

Hi Janis,

I was trying to do something similar to what Rahul is trying. Here am trying to see the no of stories and no of defects logged against each Fix version. But here the catch is, for defects we do not enter Fix version, instead we enter the same value of Fix Ver in that Affects Version. All I am trying to find is, each fix version Story Vs Defect count. Currently I am getting incorrect defect numbers. Could you please help me ?