Use both fixed and affected version

Questions & Answers
1

Hi,

i am currently using Affected version (as software release version) as Row to show number of bugs found for each SW release. In the same graph i would like to show a line which show the number of bugs that will be fixed per SW release using the Fix Version field.

Is this possible?
Thanks
Michele

2

Try to define a new calculated measure such as:

(
[Measures].[Issues created],

[Fix Version.By name].DefaultMember.Children.item([Affected Version].CurrentHierarchyMember.name),

[Affected Version].DefaultMember,
)

1 Like
3

Hi @bilbo871,

The solution proposed by @ran.lavi should work for you. Thank you Ran! One adjustment I suggest is using the Affects version dimension CurrentHierarchy.DefaultMember so the formula works for all Affects version hierarchies:

(
  [Measures].[Issues created],
  [Fix Version.By name].CurrentMember.Children.item(
    [Affects Version].CurrentHierarchyMember.Name
  ),
  [Affects Version].CurrentHierarchy.DefaultMember
)

Best,
Roberts // support@eazybi.com