Total of Descendants in Collapsed/Expanded view

Questions & Answers
2

Code for MembersHierarchy in Settings

[jira.customfield_init]
name = "INIT"
inward_link = "is contained in"
issue_type = "Initiative"
update_from_issue_key = "customfield_change"
dimension = true

[jira.customfield_change]
name = "CHANGE"
inward_link = "is contained in"
issue_type = "Change"
update_from_issue_key = "customfield_cte"
dimension = true

[jira.customfield_cte]
name = "CTE"
inward_link = "is contained in"
issue_type = "CTE"
update_from_issue_key = "epic_key"
dimension = true

Code for “leaf1_ToDo”

CASE
WHEN

IIf(

        IsEmpty(ExtractString([Measures].[Issue type],  'CTE'))
        ,
        0,
        iif(

                IsEmpty(ExtractString([Measures].[status_category],  'To Do'))

                ,
                CBool(0),
                CBool(1)
        )
)
THEN 1
END

Code for Count_in_root_ToDo

NonZero(
        Count(
                Filter(
                        Descendants([Issue].CurrentHierarchyMember.GetLinkedMember('INIT')),


                        IIf(
                                IsEmpty(ExtractString([Measures].[Issue type], 'CTE'))
                                ,
                                0,
                                iif(
                                        IsEmpty(ExtractString([Measures].[status_category], 'To Do'))

                                        ,
                                        CBool(0),
                                        CBool(1)
                                )
                        )
                )
        )
)