How do I filter issues that CONSIST of a Component?

Questions & Answers
1

Dear Community,

I am required to filter through issues to get all the issues that consist of [Component A].
Currently I tried using Bookmark in Project dimension, but it only returns to me issues = [Component A] only.

But for some of our tickets we have [Component A] + [Component B]. But using the code below, it only filters issue that have exact match [Component A] + [Component B]

Nonzero(Count(
Filter(Descendants(
[Issue].CurrentMember,[Issue].[Issue]
),
([Measures].[Issues created],
[Project].[SuperSwan].[SSBO])>0
AND
([Measures].[Issues created],
[Project].[SuperSwan].[In House])>0
))
)

I am trying to filter issues that consist of:
Component A only OR
Component A + BCDEFG…

2

Turns out using ‘.* Component A. *’ will return all tickets that contain Component A.

1 Like
3

Hi,

if the use case is to count issues having the specific component (and perhaps some other), the most effiecient solution is the tuple:

([Measures].[Issues created],
 [Project].[Component].[Component A])

This code is identical to the following:

Nonzero(Count(
Filter(Descendants(
[Issue].CurrentMember,[Issue].[Issue]
),
([Measures].[Issues created])>0
AND
CoalesceEmpty([Measures].[Issue components],"") MATCHES ".*Component A.*"
))
)

Kindly,
Janis, eazyBI support