% Completion of issue types in a period of 1 year

@shiva

In that case, you can’t use predefined measures anymore.
Try this formula when creating a new user-defined calculated measure (with integer formatting)

SUM(
  Filter(
    Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
    DateInperiod(
      [Measures].[Issue created date],
      [Time].CurrenthierarchyMember
    )
    AND
    DateInperiod(
      [Measures].[Issue resolution date],
      [Time].CurrenthierarchyMember
    )
    AND
    [Measures].[Issues resolved]>0
  ),
  CASE WHEN
  [Measures].[Issues created]>0
  THEN
  1
  END
)

When selecting this measure, make sure you enable “Nonempty” cross join for report rows for faster computing.

Best,

1 Like