Filter parent tasks

[FJ-Jay]

I want to use ICM to filter parent tasks, but I don’t know how to combine these two conditions.

Count(
Filter(
[BeCaused].[BeCaused].GetMemberByKey([Issue].CurrentMember.Get(‘BeCaused’)),
CoalesceEmpty([BeCaused].CurrentMember.Get(‘Organizations’),“”) MATCHES “.AAA.” OR
CoalesceEmpty([BeCaused].CurrentMember.Get(‘Organizations’),“”) MATCHES “.BBB.” AND
[Measures].[Issues created]>0
)
)

Count(
Filter(
[Issue.Sub-task].[Parent].GetMemberByKey([Issue].CurrentMember.get(‘Parent issue key’)),
CoalesceEmpty([Issue.Sub-task].CurrentMember.Get(‘Organizations’),“”) MATCHES “.AAA.” OR
CoalesceEmpty([Issue.Sub-task].CurrentMember.Get(‘Organizations’),“”) MATCHES ".BBB."AND
[Measures].[Issues created]>0
)
)

[gerda.grantina]

Hi @FJ-Jay ,
Welcome to the eazyBI Community!
Can you please share more details about how you would like to count ICM tasks and by which conditions? Are those formulas that you shared already producing partially the result you want to count? How you would like to see your final report?

Kindly,
Gerda // support@eazybi.com

[FJ-Jay]

Hi @gerda.grantina ,

Essentially, my goal was to collect organizational information for each ICM task based on their parent task, refer to example 1 in the diagram. However, some ICM tasks were only linked to sub-tasks rather than parent tasks, refer to example 2 in the diagram. Is there a way to retrieve the organizational information for those ICM tasks associated with sub-tasks?