# Planned vs. Completed Issues with different Version/s

**URL:** <https://community.eazybi.com/t/planned-vs-completed-issues-with-different-version-s/17439>\
**Category:** Questions & Answers\
**Created:** [June 10, 2024, 2:17pm UTC](https://community.eazybi.com/t/planned-vs-completed-issues-with-different-version-s/17439 "2024-06-10T14:17:28Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kettiko](https://community.eazybi.com/letter_avatar_proxy/v4/letter/k/5f9b8f/32.png) [@Kettiko](https://community.eazybi.com/u/Kettiko)\
**Post date:** [June 10, 2024, 2:17pm UTC](https://community.eazybi.com/t/planned-vs-completed-issues-with-different-version-s/17439/1 "2024-06-10T14:17:28Z")

</div>

I need to create a measure to show Issues with the Fix Version/s (A, B, C & D) for the same Planned Version. It needs to be considered that the Fix Version/s does not need to match the Planned Version. Planned Version is currently configured as Rows.  
Basically what I am trying to do is to show Planned Epics vs. Completed Epics. We are using the Planned Version to do a rough Planning during our Planning Conference, the Fix Version/s Field is then used by the PO when the issue is actually closed/done.  
So far I have come up with this measure:  
NonZero(  
Count(  
Filter(  
Descendants([Issue].CurrentMember, [Issue].[Issue]),  
[Measures].[Issues closed] \> 0  
AND  
NOT IsEmpty([Measures].[Issue fix versions])  
)  
)  
)  
However this is not displaying the correct data if I test it against Jira Issue Search.  
Any help is appreciated. 🙂

---

<div class="post-metadata">

**Author:** ![Kettiko](https://community.eazybi.com/letter_avatar_proxy/v4/letter/k/5f9b8f/32.png) [@Kettiko](https://community.eazybi.com/u/Kettiko)\
**Post date:** [June 12, 2024, 9:08am UTC](https://community.eazybi.com/t/planned-vs-completed-issues-with-different-version-s/17439/2 "2024-06-12T09:08:44Z")

</div>

NonZero(  
Count(  
Filter(  
Descendants([Issue].CurrentMember, [Issue].[Issue]),  
[Measures].[Issue type] = “Epic”  
AND  
([Measures].[Issues closed] \> 0 OR [Measures].[Issues created] \> 0) – Ensure that the issue is part of the dataset  
AND  
NOT [Fix Version].CurrentMember.Name MATCHES “(?i)^None$” – Exclude issues with Fix Version set to “none”  
AND  
[Planned Version].CurrentMember.Name = [Measures].[Issue Planned Version]  
)  
)  
)  
Tried this but still getting Issue with no value for Fix Version…

---

<div class="post-metadata">

**Author:** ![zane.baranovska](https://community.eazybi.com/user_avatar/community.eazybi.com/zane.baranovska/32/7209_2.png) [@zane.baranovska](https://community.eazybi.com/u/zane.baranovska)\
**Post date:** [June 12, 2024, 4:02pm UTC](https://community.eazybi.com/t/planned-vs-completed-issues-with-different-version-s/17439/3 "2024-06-12T16:02:37Z")

</div>

Hi @Kettiko,

You can simplify the calculation to get all epics with a valid fix version. Use subtraction of two tuples – one showing all epis for planned versions and subtract epics with **(no version)**

```mdx
--all epics for planned versions
(
  [Measures].[Issues created count],
  [Issue Type].[Epic],
  [Fix Version.By name].CurrentHierarchy.DefaultMember
)
-
--subtract epics for planned versions that have no fix version
(
  [Measures].[Issues created count],
  [Issue Type].[Epic],
  [Fix Version.By name].[(no version)]
)

```

If you want to show only closed issues, you can use the measure “Issus closed count”.

More details on tuple expressions are described in the documentation: [Tuple](https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/tuple).

Best,  
Zane / [support@eazyBI.com](mailto:support@eazyBI.com)

---

<div class="post-metadata">

**Author:** ![Kettiko](https://community.eazybi.com/letter_avatar_proxy/v4/letter/k/5f9b8f/32.png) [@Kettiko](https://community.eazybi.com/u/Kettiko)\
**Post date:** [June 13, 2024, 7:06am UTC](https://community.eazybi.com/t/planned-vs-completed-issues-with-different-version-s/17439/4 "2024-06-13T07:06:51Z")

</div>

Thanks @zane.baranovska! Your suggestions helps me in getting all epics with a valid fix version.  
However it is not returning the values I want to see. Let me be a little bit more precise.

I want to show for issue type Epic Planned Issues vs. Completed Issues.

 ![Bildschirmfoto 2024-06-13 um 08.58.30](https://community.eazybi.com/uploads/default/original/2X/f/f87a2a3251001f8f2b90cd516307dc990da2072c.png)

The different Iterations, Planned Versions as well as Fix Versions have the same value e.g. Version A, Version B, Version C and Version D.  
I want to show how many Epics are Planned (using Planned Version) for a specific Iteration. Additionally I want to show how many Epics are Fixed (using Fix Version) for a specific Iteration. It can also be the case that something got planned for Iteration A but got actually fixed in Iteration B.  
I hope this picture illustrates my problem a bit more.

---

<div class="post-metadata">

**Author:** ![Kettiko](https://community.eazybi.com/letter_avatar_proxy/v4/letter/k/5f9b8f/32.png) [@Kettiko](https://community.eazybi.com/u/Kettiko)\
**Post date:** [June 13, 2024, 8:05am UTC](https://community.eazybi.com/t/planned-vs-completed-issues-with-different-version-s/17439/5 "2024-06-13T08:05:06Z")

</div>

```auto
-- Combined Measure to show completed issues with Fix Version in the column of the corresponding Planned Version
NonZero(
  (
    [Measures].[Issues created count],
    [Issue Type].[Epic],
    [Fix Version.By name].CurrentHierarchy.DefaultMember
  )
  -
  (
    [Measures].[Issues created count],
    [Issue Type].[Epic],
    [Fix Version.By name].[(no version)]
  )
  +
  Sum(
    Filter(
      Descendants([Issue].CurrentMember, [Issue].[Issue]),
      [Measures].[Issues created] > 0
      AND
      [Measures].[Issue Planned Version] = [Measures].[Issue Fix Version]
    ),
    [Measures].[Issues closed]
  )
)

```

I came up with this, but somehow Im not seeing any values… ☹