How to get all issues whose Fix Versions is same as Affects version

Tried below calculated measure but no luck

( [Measures].[Issues created],
[Affects Version.By name].[Name].GetMemberByKey(
[Fix Version].CurrentMember.Key
)

Hi,

Your formula seems very close to the solution, assuming that you are using the Fix version dimension with the By Name hierarchy in your report. The function of CurrentMember by default uses the default hierarchy, which in your case is not used in the report. The CurrentHierarchyMember should fix that:

( [Measures].[Issues created],
[Affects Version.By name].[Name].GetMemberByKey(
[Fix Version].CurrentHierarchyMember.Key)

Kindly,
Janis, eazyBI support