Filter by Parent values

Questions & Answers
,
1

Hi everyone. I’m trying to filter records by their parent values, but not getting anywhere (0 results).

Can anyone help me understand what is wrong with this MDX?

Aggregate(
  Filter(
    [Issue].CurrentMember,
    [Issue].CurrentHierarchyMember.Parent.get('Delivery Team') = 'Team1'
  )
)

Thanks

2

Hi @pgordalina,

The MDX calcaution might work if the individual issue is on report rows. I would not recommend making such aggregate calculations in the “Issue” dimension as this might affect report performance significantly.

In your case, importing the “Parent Team” as a separate dimension would be a more convenient and faster solution. In eazyBI advanced settings, you can define a new dimension to check on Delivery Team and pass this value down to child issues.

For more details please and code examples, please see this documentation page: JavaScript calculated custom fields.

Best,
Zane / support@eazyBI.com