Total is mis calculated

Questions & Answers
1

Hello community,
I have this one

image
image1685×529 51.5 KB

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.
2

Hi @Giorgos

Try adding the comment with annotation to the code (first line before your existing code)

But I would recommend shorter code version for you which would work slightly faster in the report.

-- annotations.total=sum 

Sum(
  Filter(
    Filter(
      Descendants(
        [Issue].CurrentHierarchyMember, 
        [Issue].[Issue]
      ),
      DateInPeriod(
        DateParse([Issue].CurrentHierarchyMember.Get('Closed at')),
        [Time].CurrentHierarchyMember
      ) 
    ),
    
    (
      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]
)

Martins from eazyBI