Multiple Fix Version leads to multiple counting

Questions & Answers
, ,
1

Hi,

I have a similar question as Multiple Fix Version leads to double counting - Questions & Answers - eazyBI Community

I would like to display the story points of issues which have multiple fix versions. If I use Fix version in pages and I select several versions, the story points of the issues are counting several times if the issues are in several versions.

I tried this but same result :

NonZero(
SUM(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
([Measures].[Issues created])>0
),
[Measures].[Story Points created]
)
)

Could you help me ?

Sincerely,
Ludovic

2

Hi, @Ludovic

You are close! The issue can be in more the one Fix version. For your formula to work, please ignore the FixVersion.

The formula should look something like this:

NonZero(
SUM(
  Filter(
  Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
  [Measures].[Issues created]>0
  ),
  ([Measures].[Story Points created],
  [Fix Version].CurrentHierarchy.DefaultMember)
)
)

I’m using a tuple to ignore the multiple Fix versions selected in the Page filter. The relevant issues will be selected in the Filter part. Now, for selected issues, sum the Story Points and “don’t double”—ignore the version.

Kindly,
Ilze