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?