Calculate Sum Over a Measure for a specific Filtered Set

My Goal: I want to calculate the sum for the Measure - Xray Test Runs - for a specific set of Test Plans.

My Report is structured like this:

My row dimensions are set to Issues.

For our Jira setup I have a specific property that is the same for this Issue and the related Xray Test Plans. So in order to get the related Test Plans for my Issue I can filter and check this specific Property, which works fine for my calculated measure - Generate Test Plan for Issue:

Generate(
Filter(
[Xray Test Plan].[Plan].Members,

[Xray Test Plan].CurrentMember.GetString(“Property Name”)
= [Issue].CurrentHierarchyMember.GetString(‘‘Property Name’’)),

[Xray Test Plan].CurrentMember.Name,

", "

)

What is confusing to me is that this measure works perfectly fine but this logic doesn’t work for my calculated measure when i want to sum up a measure for this set of test plans like this:

Sum(
Filter(
[Xray Test Plan].[Plan].Members,

[Xray Test Plan].CurrentMember.GetString(“Property Name”)
= [Issue].CurrentHierarchyMember.GetString(‘‘Property Name’’)),

[Measures].[Xray Test Runs]

)

Does anyone know how i can get this to work or if there is another solution to my problem without changing the row dimension, that wouldn’t work for my report requirements.

First I thought it had something to do with the CurrentHierarchyMember but if i use a different filtering logik the problem is still there so I think it might be related to the fact that i want to filter over Members which are not selected at rows, but this works fine for the Generate and Filter combination, so what is the difference when I use Sum and Filter together?

Hi @Julia,
Welcome to eazyBI Community! Thanks for posting your question!

The simplest solution would be to put the Xray Test Plan dimension in rows instead of Issues, and then use the Xray Test Runs measure directly. This would give you accurate sums without needing complex calculations.

However, if you need to keep Issues in rows for specific report requirements, could you please clarify what you are trying to achieve with this report?

Best wishes,

Elita from support@eazybi.com