Measure - Resolved ticket with Field vale was in

Hi,

I need to calculate number of resolved ticket with a text field value that assumed a specific value (currently or on the past).
I tried the following measure but it doesn’t work :

NonZero(
Count(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
[Measures].[Issues resolved] > 0 AND
Count(
([Measures].[Transitions from],
[Transition Field].[GCO],
[GCO].[MY FIELD VALUE]
)
)>0
)
)
)

What am I missing?
Fabio

Hey @fabio.racobaldo

Try this formula:

Sum(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
DateInPeriod(
  [Measures].[Issue resolution date],
  [Time].CurrentHierarchyMember
)
AND
(
([Measures].[Transitions from],
[Transition Field].[My Field Name],
[My Field Name].[Green],
[Time].CurrentHierarchy.DefaultMember
)>0
OR 
[Measures].[Issue My Field Name] = "MY FIELD VALUE"
)

),
CASE WHEN
[Measures].[Issues resolved] > 0 
THEN
1
END
)

Martins / eazyBI

Hi Martins,

Green should be modified MY FIELD VALUE. BTW, it seems that rule

([Measures].[Transitions from],
[Transition Field].[My Field Name],
[My Field Name].[Green],
[Time].CurrentHierarchy.DefaultMember
)>0

is not retrieving tickets.
Please helps,
Fabio

Solution provided by Martin can not be applied because my field is a multi-value field.

As workaround I used my own scripted field (provided by ScriptRunner) in order to flag ticket in which my field assumed that value (ChangeHistory supported me in order to perform that check).

Measure, on eazyBI side, has been configured based on that field and my report works like a charm now.

Regards,
Fabio