# Exclude issues in certain Transition Status and specific Status

**URL:** <https://community.eazybi.com/t/exclude-issues-in-certain-transition-status-and-specific-status/11914>\
**Category:** Questions & Answers\
**Tags:** report-specific, calculatedmembers, mdx\
**Created:** [March 1, 2023, 4:41am UTC](https://community.eazybi.com/t/exclude-issues-in-certain-transition-status-and-specific-status/11914 "2023-03-01T04:41:49Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![maferhc](https://community.eazybi.com/letter_avatar_proxy/v4/letter/m/b5e925/32.png) [@maferhc](https://community.eazybi.com/u/maferhc)\
**Post date:** [March 1, 2023, 4:41am UTC](https://community.eazybi.com/t/exclude-issues-in-certain-transition-status-and-specific-status/11914/1 "2023-03-01T04:41:49Z")

</div>

I need to create a report of issues that haven’t been in a specific _Transition Status_ and are in a specific **Status**. In this case, the _Transition Status_ restriction is “_Escalated_” and the Status is “_Resolved_”. That is to say the report should return all the Issues in Status = “Resolved” and never have passed by Transitions Status “Escalated”.  
I defined a calculated member in the _Transition Status_ dimension that aggregates the statuses I am interested in using the next expression (expression1):

Aggregate(  
Except(  
[Transition Status].[Transition Status].Members,  
{[Transition Status].[Escalated],  
[Transition Status].[Cancelled] (optional restriction)  
}  
)  
)

Besides, I use expression1 in a measure

([Measures].[Transitions to status issues count],  
[Transition Status].[expression1])

However, I haven’t been able to filter the result with the specific Status. Is it possible someone will give me a hand in completing my report?

Thanks in advance 🙂

---

<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:** [March 1, 2023, 2:52pm UTC](https://community.eazybi.com/t/exclude-issues-in-certain-transition-status-and-specific-status/11914/2 "2023-03-01T14:52:57Z")

</div>

Hi,

The solution to this use case requires iteration through the issues to count issues that never were in some statuses.

The formula could look like this:

```auto
NonZero(Count(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
  [Measures].[Issue status]="Resolved"
  AND
    IsEmpty(
      ([Measures].[Transitions to status],
       [Transition Status].[Some statuses])
    )
  )
))

```

Some statuses is an aggregated members of statuses you wish to exclude:

```mdx
Aggregate(
{[Transition Status].[Escalated],
[Transition Status].[Cancelled]}
)

```

Kindly,  
Janis, eazyBI support

---

<div class="post-metadata">

**Author:** ![maferhc](https://community.eazybi.com/letter_avatar_proxy/v4/letter/m/b5e925/32.png) [@maferhc](https://community.eazybi.com/u/maferhc)\
**Post date:** [March 6, 2023, 9:31pm UTC](https://community.eazybi.com/t/exclude-issues-in-certain-transition-status-and-specific-status/11914/3 "2023-03-06T21:31:54Z")

</div>

Janis, thank you for your answer.

I have applied the solution according to your indications. However, the obtained results are not filtered as is required. These are in the column ‘Resolved by Support Team’. I have checked them and some of them have passed by the transition stated ‘Escalated’.

 ![image](https://community.eazybi.com/uploads/default/original/2X/a/a196cd7a7df763af29f7e04ffe2cb625b2852c5a.png)  
Besides, the number shown is quite high in comparison to the real state.  
Furthermore, I included in the filter **DateInPeriod** , trying to filter the Issues updated in the period selected: “Current Month”

DateInPeriod(  
[Measures].[Issue resolution date],  
[Time].CurrentHierarchyMember )

But It didn’t work, it didn’t show any number as result.

At the end I have:

**Column - Resolved by Squads**

NonZero(Count(  
Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),  
[Measures].[Issue status]=“Resolved”  
AND  
(  
([Measures].[Transitions to status],  
[Transition Status].[_TicketsEscalated_]) \> 0  
)  
)  
))

Where **TicketsEscalated** =  
Aggregate(  
{[Transition Status].[Escalated]}  
)

**Column - Resolved by Support Team**

NonZero(Count(  
Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),  
[Measures].[Issue status]=“Resolved”  
AND  
IsEmpty(  
([Measures].[Transitions to status],  
[Transition Status].[TicketsEscalated])  
)  
)  
)  
)

I hope you can help me!!  
Thank you.