Filters not working due to new calculated measure

Questions & Answers
,
1

Hi eazyBI community,
can someone help me with the following situation:

I’ve created a new calculated measure:

NonZero(Count( 
  Filter(
    [Issue.Epic].CurrentHierarchyMember.Children,
    DateDiffDays(
      [Issue.Epic].CurrentHierarchyMember.Parent.get('Target date'),
      [Issue.Epic].CurrentHierarchyMember.get('Due date')
    )>= -315 
    AND 
    DateDiffDays(
      [Issue.Epic].CurrentHierarchyMember.Parent.get('Target date'),
      [Issue.Epic].CurrentHierarchyMember.get('Due date')
      )  <= 0 
  )
))

This measure compares a due date (of children of the epics) with the Target date of the linked epics. If the difference meets the defined criteria, they are counted.
This formula works perfectly fine, unfortunately additional filters have no more impact on the results.
For example I only want to show Epics with a specific customfield or label in my table… this doesn’t work. There is always the same result/filtered data.
Does my new calculated measure limit the data set so that these filters no longer apply? Or is the wrong hierarchy level being used?

Thanks in advance,
Robin!

2

Hi @Consultig_Rob

You are almost there! The formula still needs to use some measure that relates filtered issues to the report’s context (e.g. Page filters), so I added one more condition with a measure for that.

NonZero(Count( 
  Filter(
    [Issue.Epic].CurrentHierarchyMember.Children,
    DateDiffDays(
      [Issue.Epic].CurrentHierarchyMember.Parent.get('Target date'),
      [Issue.Epic].CurrentHierarchyMember.get('Due date')
    )>= -315 
    AND 
    DateDiffDays(
      [Issue.Epic].CurrentHierarchyMember.Parent.get('Target date'),
      [Issue.Epic].CurrentHierarchyMember.get('Due date')
      )  <= 0 
  )
    AND
    ([Measures].[Issues created],
     [Time].CurrentHierarchy.DefaultMember)>0
))

Best,
IlzeLA, support@eazybi.com

1 Like