Hello,
I have a problem with my custom measure
This measure calculates the time workdays to solve the tickets, but subtracting the time in which it is in two specific transitions. The problem is that if from the report, I filter by IssueType, it is subtracting the time for which they go through those transitions but of any IssueType without applying the filter that I indicate outside the formula and I have had to put the filter inside the measeure to make it work.
What should I do to make it filter correctly without doing this? Thank you so much
NonZero(Avg(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
DateInPeriod(
[Issue].CurrentHierarchyMember.get(‘Resolved at’),
[Time].CurrentHierarchyMember
)
AND ([Measures].[Issue type] = “Incidencia”
OR [Measures].[Issue type] = “Consulta”
OR [Measures].[Issue type] = “Bug”)
AND
DateCompare(
[Measures].[Issue resolution date],
‘2022-01-01’
)>0
),
[Measures].[Total resolution workdays]
Sum(
{[Transition Status].[Esperando por el cliente]},
([Measures].[workdays in transition status],
[Time].CurrentHierarchy.DefaultMember)
)
Sum(
{[Transition Status].[Pendiente de instalación]},
([Measures].[workdays in transition status],
[Time].CurrentHierarchy.DefaultMember)
)
))