Measure filtering : except some status

Questions & Answers
#1

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

#2

Hi there,

Nobody has an idea ?

I just need some filtering, based on the issue status… and honnestly I have no idea how I can do that ?

Thanks

#3

Status is a dimension, why didn’t you tried to filter from dimensions. it will be easily achievable.
Let me know if you have any specific reason for that.

#4

Thanks,

My understanding is that I need to filter on the [Issue] dimension, because I’m interested to calculate the AVg time between 2 status (PROGRESS & DONE), and they come from the [Issue] dimension.

I need this: DateDiffDays([Measures].[Issue Progress start date], [Measures].[Issue resolution date])

If I try this:

Avg(

Filter([Status].[Status].Members, [Status].CurrentMember.Name = “DONE”),
DateDiffDays([Measures].[Issue Progress start date], [Measures].[Issue resolution date])

)

I have no result.

Any idea?

#5

I am unable to find “Issue Progress Start date”.

Try this…

CASE WHEN [Measures].[Issues resolved] > 0 THEN
[Measures].[Total resolution days] / [Measures].[Issues resolved]
END

#6

Thanks,

But the resolution does not start once the issue move to “in progress” but once it is created.