Filter ssues that have both Component 1 AND Component 2

[tzengtif]

Hello!

In one report, components are used both for the process name and a team name. We want to filter issues both by a specific process and specific team. However, when using the multi-select in pages, that will gives me all issues with that specific process and all issues with that specific team and not both. In other words, I want issues with component 1 AND component 2 rather than issues with component 1 OR component 2. I only want the orange section in the image below, but I’m getting the whole diagram.

How can I achieve this? Thanks!

[rensch]

Hello @tzengtif,

I just created a report to test my suggested solution:
I used Issue → All hierarchy level members → Issue for the rows and Issue components as measure. In the table view you can left click at the issue components columns and select filter → matches. Then you can enter a regex like:

component1,component2|component2,component1

Since the components appear to be in alphabetical order, you can use a shorter regex:

component1,component2

I hope this helps.

[janis.plume]

Hi,

The following custom measure counts the :

If your report uses the Issue dimension, you can utilize the feature that multiple value fields’ multiple selections give the number of how many members match the selection. In the case if you must filter two specific components, you can see that Issues created with the filter gives “2” for the issues with both components:

Applying the row filter gives the issue list:

For counting such issues without the issue dimension in the report, the same logic must be implemented in the formula:

NonZero(Count(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
  [Measures].[Issues created]=2
  )
))

Now the count works with any report, provided both components are used in the page filter:

Kindly,
Janis, eazyBI support

[Charles]

Hi @janis.plume Could you please share the measures to me？ I also need filter two components in one issues. But I use project bookmark to filter. and no results as below formula.

Aggregate(
Filter(
[Component].[Component].Members,
[Component].CurrentMember.Name = “RTS”

AND
[Component].CurrentMember.Name=“OP_AT200”
),
[Measures].[Issues history]
)