Hey team,
I am trying to develop a range pf reports that allow to track activities beneath a specific phase. For example, Phase issue type abc-123 has a number of issues underneath at various layers.
I have tried the below as a calculated measure:
Aggregate(
Descendants(
[Issue].[abc-123],
[Issue].[Issue]
)
)
This didn't show any issue under abc-123. So I then tried:
Aggregate(
Filter(
Descendants([Issue].[abc-123], [Issue].[Issue]),
[Measures].[Issue Type] <> "Epic"
)
)
Again, no result.
I then tried this:
NonZero(Count(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
[Measures].[Issue Parent] = "ABC-123"
)
))
Again no response.
Are there any ideas on how I can achieve the ability to report on all activities under this Phase abc-123.
Thanks in advance
Dave