Issues by Transition to status first date - distinct count

Questions & Answers
2

Hi @Ivan_Sidyakin,

The measures “Transitions to status” woudl coun issue in each period when it moved to a specific status (see documentation Import issue change history). If you would like to count issues only for the first period when this transition happened, then you should create a new calcauted measure.

The calculation would iterate through individual issues. Check whether the “Transition to status first date” was in the selected period for each issue.

NonZero(Count(
  --set of issues
  Filter(
    --iterate through individual issues
    DescendantsSet([Issue].CurrentMember,[Issue].[Issue]),
    --check if first ever status change to Customer Approval was in the selected period
    DateInPeriod(
      ([Measures].[Transition to status first date],
      [Transition Status].[Customer Approval]
      [Time].CurrentHierarchy.DefaultMember),
      [Time].CurrentHierarchyMember)
  )
)

Set measure formatting to Integer,.
For more details on calcauted measures and used functions described in the documentation, see the chapter on Set expressions: Calculated measures.

Check out also Community posts on similar use cases:

Best,
Zane / support@eazyBI.com