Count of fixVersions based on calculated measure in the fixVersion dimension

Questions & Answers
1

I’m attempting to get a count of fix versions based on what they’re named (i.e. starts with xyz) for a rolling 3 years (i.e. 2020, 2021 and 2022).
I used this formula:

NonZero(
  Count(
    Filter(
      Descendants([Fix Version].CurrentHierarchyMember,[Fix Version].[Version]),
      DateInPeriod(
        [Fix Version].CurrentMember.Get('Release date'),
        [Time].CurrentHierarchyMember
      )
      AND
      ([Time].CurrentHierarchy.DefaultMember,[Measures].[Issues created]) > 0
    )
  )
)
``` and attempted to adapt it to my needs.
NonZero(
  Count(
    Filter(
      Descendants([Fix Version].CurrentHierarchyMember,[Fix Version].[Version]),
      DateInPeriod(
        [Fix Version].CurrentMember.Get('Release date'),
        [Time].CurrentHierarchyMember
      )
      AND
      ([Time].[Year].CurrentDateMember,[Measures].[Issues resolved]) > 0
     AND
      [Fix Version].CurrentMember.Name NOT MATCHES ".*Library*." 
       AND
      [Fix Version].CurrentMember.Name MATCHES "^PMTE.*" 
        OR 
      [Fix Version].CurrentMember.Name MATCHES "^PMWE.*" 
        OR
      [Fix Version].CurrentMember.Name MATCHES "^Websvc.*" 
        OR 
      [Fix Version].CurrentMember.Name MATCHES "Android*.*" 
        OR
      [Fix Version].CurrentMember.Name MATCHES "iOS*.*" 
    )
  )
)

I get a result, but it's pulling back the wrong # of versions...over twice as much. If I try to select one of the calculated measures for the aggregated group of fixVersions, I get no results.  Any suggestions on how I can fix this?
2

Hi @ShelPrice

You are very close.
Try this formula with parenthesis for OR expressions and measure as pointer

  Sum(
    Filter(
      Descendants([Fix Version].CurrentHierarchyMember,[Fix Version].[Version]),
      DateBetween(
        [Fix Version].CurrentMember.Get('Release date'),
        [Time].[Year].CurrentDateMember.Lag(2).startdate,
        [Time].[Day].CurrentDateMember.startdate
      )
     AND
      [Fix Version].CurrentMember.Name NOT MATCHES ".*Library*." 
       AND
      ([Fix Version].CurrentMember.Name MATCHES "^PMTE.*" 
        OR 
      [Fix Version].CurrentMember.Name MATCHES "^PMWE.*" 
        OR
      [Fix Version].CurrentMember.Name MATCHES "^Websvc.*" 
        OR 
      [Fix Version].CurrentMember.Name MATCHES "Android*.*" 
        OR
      [Fix Version].CurrentMember.Name MATCHES "iOS*.*" )
    ),
    CASE WHEN
    Sum((
    [Time].CurrentHierarchy.DefaultMember,
    [Measures].[Issues resolved]
    ))>0
    THEN
    1
    END
  )

Martins / eazyBI