No data found when drilling through issue

Questions & Answers
1

Hi,
I’m trying to do display all the epics with no target end set.

To do this, I created a new calculated member with this code:

Aggregate(
  Filter(
	    Descendants([Issue].CurrentMember, [Issue].[Issue]),
	    [Measures].[Issues with target end] is EMPTY
)
)

It seems to work, the only thing is that when I try to drill through issues I receive a “no data found” message:

Capture

I guess there’s something wrong with my code (the aggregate function?) but I wasn’t able to find anything useful to solve this issue.

Thanks for your help

2

I think it might be: IsEmpty( [Measures].[Issues with target end])

Aggregate(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
IsEmpty( [Measures].[Issues with target end])
)
)

as per: https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-members/mdx-function-reference/isempty

Hope this helps.

3

Thanks for your suggestion.
Using the IsEmpty function has more sense in my calculated member.

Unfortunately, this doesn’t solve my initial issue as I’m still not able to drill through issues.

4

Hi,

In this case, you could try another approach when creating a new calculated measure:

[Measures].[Issues created count]
-
[Measures].[Issues with target end]

But this approach would not work as you expect when “Time” dimension is used in reports.
Martins / eazyBI team

5

Hi,
thanks for your help, now it’s working as I wanted. :grinning:

Just to understand: what was wrong with my approach?

Best,
Claudio

6

Hi,

Your approach did not have an actual link to numeric measure (which is used for report context).
You used the “IsEmpty” function with actual measure but you were searching for empty context, that is why report got confused.

Martins