Count issues with filter date or empty

Questions & Answers
4

Yes, I found an error in the formula. However, it was related to pulling in values for issues with the Contract execution date.

Function DateCompare gives results as -1 (date is before), 0 (date is equal), or 1(date is after). So, the criteria > 1 does not work with DateCompare results.

Here is an updated formula:

NonZero(
  Sum(
    Filter(Descendants([Issue].CurrentMember, [Issue].[Issue]),
      IsEmpty([Measures].[Issue Contract Execution Date]) OR 
      (DateCompare(DateWithoutTime([Measures].[Issue Contract Execution Date])
        ,DateParse('2018-12-31')) = 1)
    ),
    -- counter by measure works as a filter as well:
    ([Measures].[Issues created],
	 [Time].CurrentHierarchy.DefaultMember)
  )
)

Daina / support@eazybi.com

1 Like