Only display Closed Issues in highest Value of Row

Questions & Answers
1

Hi,

I am creating a report for Planned vs Accepted Features in a PI. I am using Created for Planned and Closed for Accepted.

We use a Custom Field for PI with Values that increment "NRO_22_1, NRO_22_2…)

Whilst Features should only have one PI, there are times when they have two. Created show correctly in two PI’s. I want to have closed only show in the row with the highest value of PI. Is this possible?

image
image1793×639 47.3 KB

2

Hi,

A solution to this use case could be the following custom measure:

NonZero(Count(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
  [Measures].[Issues closed]>0
  AND
  [Program Increment].CurrentHierarchyMember is
  Order ([Program Increment].[Program Increment].GetMembersByKeys([Measures].[Issue Program Increment]), 
         [Program Increment].CurrentHierarchyMember.Name,DESC).Item(0)
  )
))

This formula assumes that Program increment names can be ordered alphabetically in descending order, giving the latest Program increment in the first place.

Kindly,
Janis, eazyBI support

3

Hi @janis.plume

Thank you so much for this. It works perfectly.

Cheers
Andy

1 Like