Assistnace with Historical Status vs Opened in Last X days

EX: For the last N days I have 40 Newly Created Tickets of a certain issue type.
of those 40 i’d like to know how many of those 40 reached a particular status.

Use Case. A customer submits a ticket for a hardware issue. I’d like to determine how many issues we can Fix vs Having a customer send the unit(s) back to us.

Thanks in advance.

Hi @mtterry

Try this formula for the calculated measure.

Sum(
Filter(
DescendantsSet([Issue].CurrentMember,[Issue].[Issue]),
[Measures].[Issue type] = "Certain issue type"
AND
DateInperiod(
[Measures].[Issue created date],
[Time].CurrentHierarchyMember
)
),
CASE WHEN
(
[Measures].[Transitions to status],
[Transition Status].[Particular status],
[Time].CurrentHierarchy.Defaultmember
)>0
THEN
1
END
)

Don’t forget to select the “integer” or “decimal” format for this calculated measure.

It should count issues with certain issue type created in the selected/displayed period if they reached a “particular status” at least once at any time.

Martins / eazyBI