Hello community,
I have this one
The issue is that the measure within the frame does not calculate the total number correct.
Sum(
Filter(
Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
NOT IsEmpty([Issue].CurrentHierarchyMember.Get('Created at')) AND
NOT IsEmpty([Issue].CurrentHierarchyMember.Get('Closed at')) AND
DateInPeriod(
DateParse([Issue].CurrentHierarchyMember.Get('Closed at')),
[Time].CurrentHierarchyMember
) AND
(
Year(DateParse([Issue].CurrentHierarchyMember.Get('Created at'))) < Year([Time].CurrentHierarchyMember.StartDate)
OR
(
Year(DateParse([Issue].CurrentHierarchyMember.Get('Created at'))) = Year([Time].CurrentHierarchyMember.StartDate)
AND
Month(DateParse([Issue].CurrentHierarchyMember.Get('Created at'))) < Month([Time].CurrentHierarchyMember.StartDate)
)
)
),
[Measures].[Issues closed count]
```Kindly requested your help.
Thank you.