Consolidated sum

Hello
Here are some explanations of my problem :

  • 7 milestones have a delivery date in january
  • 5 have a closure date in january
    But only 3, have a delivery date AND a closure date in january.
    How is it possible to have the 3 value in the first red cycle

Same thing for February :

  • 10 milestones have a delivery date in february
  • 8 have a closure date in february
    But only 6, have a delivery date AND a closure date in february.
    How is it possible to have the 6 value in the second red cycle

Thanks

Hi,

This use case requires custom formula counting the aggregated number of issues where both measures are not empty. The formula is the following:

NonZero(Count(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
  [Measures].[Issues with free_field_date_02]>0
  AND
  [Measures].[Issues with closure date]>0
  )
))

Kindly,
Janis, eazyBI support