Get fixVersion name from [Issues] (not [Measure].[fix versions])

Questions & Answers
, ,
4

So finally I also found how to translate from fix versions IDs in the issue to the fix version names:

      [Fix Version].[Version].getMemberNamesByKeys(
        [Issue].CurrentHierarchyMember.get('Fix version IDs')
      )

this allows to crate custom measures filtering e.g. sum of work for issues where the fix version names match some pattern:

CoalesceEmpty(
Sum(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    LCase(
      [Fix Version].[Version].getMemberNamesByKeys(
        [Issue].CurrentHierarchyMember.get('Fix version IDs')
      )    
    ) MATCHES '.*must.*'
  ),
  [Measures].[Original estimated hours]
),0)
1 Like