Hi,
I have the current measure and it works well:
Avg(
Filter(
Descendants([Issue].CurrentMember,[Issue].[Issue]),not IsEmpty([Measures].[Issue Progress start date])
AND
– show when issue were resolved
DateInPeriod([Measures].[Issue resolution date], [Time].CurrentHierarchyMember)
),
CASE WHEN [Measures].[Issues with Progress of resolved issues] > 0
THEN
DateDiffDays(
[Measures].[Issue Progress start date],
[Measures].[Issue resolution date])
END
)
Then I try to bypass all the issue that are “REJECTED” (or some other specific status) by adding one line to the filtering, but I still got all the REJECTED issues:
Avg(
Filter(
Descendants([Issue].CurrentMember,[Issue].[Issue]),not IsEmpty([Measures].[Issue Progress start date])
AND
NOT [Issue].CurrentHierarchyMember.GetString(‘Epic Status’) = “REJECTED”
AND
– show when issue were resolved
DateInPeriod([Measures].[Issue resolution date], [Time].CurrentHierarchyMember)
),
CASE WHEN [Measures].[Issues with Progress of resolved issues] > 0
THEN
DateDiffDays(
[Measures].[Issue Progress start date],
[Measures].[Issue resolution date])
END
)
I have also tried with: NOT [Status].CurrentMember.Name = “REJECTED”
But still, I find no way to filter on some status. Any idea of the problem here?
Thanks