Get/Convert Set to different Hierarchy

Hi All,

I calculate the intersection of the fix versions in the current issue and the the fix versions selected in the pages:
Intersect(
[Fix Version].[Version].GetMembersByKeys(
[Issue].CurrentHierarchyMember.get(‘Fix version IDs’)
),
ChildrenSet([Fix Version.By name].CurrentHierarchyMember)
)

This works as long as the Fix Version in pages uses all hierarchy level members “Version”.
I would prefer to use ‘by Name’ to not have duplicates in the pages selection but then I get different elements in the set due to the hierarchy being different:

image

The intersection if these 2 sets is empty whereas I would like to get Alpha1 as that is in both sets.

I tried

[Fix Version. by Name].GetMembersByKeys(
[Issue].CurrentHierarchyMember.get(‘Fix version IDs’)
)

to get a compatible set for by name but this is rejected.

Is there a way to get/or convert a set to a different hierarchy?

Thx

Hi @aherz

Please try a formula like this:

Generate(
  Filter(
    ChildrenSet([Fix Version.By name].CurrentHierarchyMember),
    [Measures].[Issues created]>0
  ),
  [Fix Version].CurrentHierarchyMember.Name,
  ","
)

Let me know if this works as expected!
​Best regards,
​Nauris

Hi Nauris,

the Generate above will sort of give me what I am looking for but as a String, I need a set :slight_smile:

If you look at the green example in my post, I need to translate e.g. [Fix Version.By name].[(EV-v1.1r1-Alpha1)] into [Fix Version].[Plan Engineering].[Released].[(EV-v1.1r1-Alpha1)] and I am looking for the actual objects in the set (so I can intersect them with other sets) not the textual representation.

Thank you.