Filter out issues, where specific measure is 0

Questions & Answers
1

I have a calculated measure, which shows count of linked issues.
I need to filter out issues, where this count is 0, but can’t find a way.
Tried to search eazyBI documentation for “Search and bookmark”, which has been suggested in some answers as the way, but no luck :slight_smile: I don’t even have a clue, what exactly must be written in the Search field - Issue key? JQL? Some expression?
Am I missing something? :slight_smile:

2

I found this in eazyBI documentation:
Aggregate(Filter(
[Sprint].[Sprint].Members,
NOT [Sprint].CurrentMember.getBoolean(‘Closed’)
AND
NOT isEmpty([Measures].[Sprint Start Date])
))

Tried to re-use it and created:

Aggregate(
Filter([Issue].[Issue].Members,
NOT isEmpty([Measures].[Linked support tickets])
))

No success :frowning:

3

Hi,

The following custom formula should be working for most of cases:

NonZero(Count(Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
isEmpty([Issue].CurrentHierarchymember.Get('Is Blocked'))
AND
[Measures].[Issues created] > 0
)))

Note to check that you use the correct name of the link you have imported. In my case, I have imported the “Is Blocked” link with the following settings:

[jira.customfield_is_blocked_link]
name = "Is Blocked"
inward_link = "is blocked by"
multiple_values = true
dimension = true

Kindly,
Janis, eazyBI support