Help. The sum of issues no showing in the calculated measure that I created

I need create a report that tracks how many times a bug passes through a certain transition.
For each project I must count e show if passes 1 time in X transition or 2 times or 3 … and i present this measures in columns.

For good presentation, I created calculated member that aggregate the issues per project, (with a fancy name), for example, the issues of CBB project, I did “aggregate([issue].[CBB])” and named as “Squad Captação Bancaria”, and when I expand, I can see each issue for the criterias.

When I use only the tuple “[measure].[pre-b]” on columns “Totals”, everything is showing correctly, but when I try separate per “X recorrences” of certain transition per project/issue, my calculated members came back empty.

I need that, for example, the number the appears in “Squad Captação Bancaria” be the same number that appears in “CBB”

This is how my “X Recorrence” calculated measures looks like:

[Measures].[1 Recorrence] =

CASE WHEN
    [Issue].CurrentHierarchyMember.Level.Name = 'Issue'
THEN
    CASE
        WHEN [Measures].[Pre-B] = 1
        THEN 1
    END
ELSE
   CASE WHEN [Issue].CurrentHierarchyMember.Level.Name = '(All)'
   THEN Sum(
          Filter([Issue].CurrentHierarchyMember.Children, [Measures].[Pre-B] = 1),
        [Measures].[Transitions to status]
        )
   ELSE
    Sum(
        Filter(
            - `Preformatted text`- iterate through Issue dimension "Issue" level
            Descendants([Issue].CurrentMember,[Issue].[Issue]),
            -- return a set of issues matching condition
            [Measures].[Pre-B] = 1
        ),
        - - evaluate the set of issues over the measure below
        [Measures].[Transitions to status]
    )
   END
END

My “Totals” :
[Measures].[Totals]=

-- In "[Measures].[Pre-B]" contains ([Measures].[Transitions to status],[Issue Type].[Bug])
[Measures].[Pre-B]

Hi @RebecaAdamuz
Welcome to the eazyBI community! :wave:

I see that you are having a tuple for your measure “Pre-B”:

([Measures].[Transitions to status],[Issue Type].[Bug])

You can use directly this measure in your report and it will aggregate the values in the Issue dimension from children up to the parent.
In this case, I also would suggest using the default project hierarchy from the Issue dimension to see all status transitions for the bug issue type per project. Creating a calculated member in the Issue dimension is not the best practice as it can result in performance issues.

See how the tuple automatically aggregates value to the Project level in the Issue dimension.

best,
Gerda // support@eazyBI.com

After try a lot things, I figure out. I used “descendantsSet()”

CASE WHEN
    [Issue].CurrentHierarchyMember.Level.Name = 'Issue'
THEN
    CASE
        WHEN [Measures].[Pre-B] = 2
        THEN Val([Measures].[Pre-B]) 
    END
ELSE
   CASE WHEN [Issue].CurrentHierarchyMember.Level.Name = '(All)'
   THEN
      Sum(
             Filter(
                DescendantsSet([Issue].CurrentMember,[Issue].[Issue]),
                [Measures].[Pre-B] = 2
             ),
             [Measures].[Transitions to status issues count]
      )
   ELSE
    Sum(Filter(
            -- iterate through Issue dimension "Issue" level
            Descendants([Issue].CurrentMember,[Issue].[Issue]),
            -- return a set of issues matching condition
            [Measures].[Pre-B] = 2),
        -- evaluate the set of issues over the measure below
        [Measures].[Transitions to status issues count])
   END
END

'Cause descendantsSet can catch aggregate children