Hi Gerda,
I am attempting to summarize data using my new custom issue link dimension [Test Findings] and I’m finding that the total sum is not showing up for my calculated measures.
For the basic count of linked Test Findings, that summarizes well using the following measure code:
-- annotations.group = 4 Issue links and hierarchies
Case
When
[Issue].CurrentMember.Level.Name = "Issue"
AND
[Test Findings].Currentmember is [Test Findings].Defaultmember
Then
-- retrieve Bugs information from Issue property Bugs
Nonzero(Count(
[Issue].CurrentHierarchy.GetLinkedmembers('Test Findings')
))
Else
-- total calculation for any issue, data on Bugs level
NonZero(Sum(
Descendants([Test Findings].Currentmember, [Test Findings].[Test Findings]),
-- counts how many times Bugs are reference with issues, this works as a filter as well
[Measures].[Issues created]
))
End
The result is shown in the screenshot, with a total of 33 linked ‘Test Finding’ issue types for the Issue Log Key:
What I’d like to do is count the total number of linked ‘Test Finding’ issue types that are NOT of status closed or canceled, and have that total appear on the ‘All Test Findings’ level for a nice summary.
I have a calculated measure to identify ‘Linked Test Finding Status’ and that appears to be working. Code below:
-- Linked Test Finding Status
-- annotations.group = 4 Issue links and hierarchies
[Status].[Status].getMemberNameByKey(
[Test Findings].CurrentHierarchyMember.get('Status ID')
)
However the sum calculation on “Count of Not Closed/Canceled Linked Test Findings” calculated measure is not appearing on the ‘All Test Findings’ row as I would expect. Here is the code I have for that calculation right now, where the SUM / FILTER does not appear to be working. The Pages should not have an impact on this view as I’ve tested changing this and there are no filters applied to the report.
-- Count of Not Closed/Canceled Linked Test Findings
-- annotations.group = 4 Issue links and hierarchies
Case
When
[Issue].CurrentMember.Level.Name = "Issue"
AND
[Test Findings].Currentmember is [Test Findings].Defaultmember
Then
-- retrieve Bugs information from Issue property Bugs
Nonzero(Count(
Filter(
[Issue].CurrentHierarchy.GetLinkedmembers('Test Finding'),
[Measures].[Issue status] NOT MATCHES '^Closed$|Canceled$')
))
Else
-- total calculation for any issue, data on Bugs level
NonZero(Sum(
Filter(
Descendants([Test Findings].CurrentMember, [Test Findings].[Test Findings]),
[Measures].[Linked Test Finding Status] NOT MATCHES "^Closed$|^Canceled$"),
-- counts how many times Bugs are reference with issues, this works as a filter as well
[Measures].[Issues created]
))
End
Thanks!