Filter issues by JIRA assignees in 2 groups (eazyBI)

[Seifallah Bellassoued]

Hello,

I want to filter assignee by all Members who are in 2 groups on the same time. for example on Developers group and Approvers groups.

I found on the doc this filter.

Filter(
[Reporter].[User].Members, 
CoalesceEmpty([Reporter].CurrentMember.get('Groups'), '') MATCHES '.*developers.*'
)

I can filter by only developers group but not Approvers group.
Any help pleaze ?
Thanks in advance.
Regards,
Seif,

[Martins Vanags -eazyBI- · Accepted solution]

Hi @Seifallah Bellassoued 

Why woud you use the "Reporter" dimension if you need to filter assignees?

The way I understand your question you need to create a calculated member in the "Assignee" dimension using the following formula:

Filter(
[Assignee].[User].Members, 
CoalesceEmpty([Assignee].CurrentMember.get('Groups'), '') MATCHES '.*developers.*'
AND
CoalesceEmpty([Assignee].CurrentMember.get('Groups'), '') MATCHES '.*approvers.*'
)

Martins / eazyBI

[Seifallah Bellassoued]

Thanks @Martins Vanags -eazyBI- it works.

For your remak, i just copy the code from the docs. But, you have right i should put assignee instead of Reporter.

Have a great day !