How to append and sum story points in eazybi

Hi
I am very new to eazybi, I have a very unique task. For each issue I need to
1.sum all the storypoints
2. replace storypoints with 3 where storypoints are equal to null, and sum the new storypoints.
Many thanks

Hi @sid149

Welcome to the Community! :slight_smile:

  1. You can use the “Story Points created” measure from the Measures dimension.

  2. You can define a new calculated measure in the Measures dimension with the following formula:

Sum(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    IsEmpty([Issue].CurrentMember.Get('Story Points'))
  ),
  CASE WHEN
  [Measures].[Issues created]>0
  THEN
  3
  END
)
+
[Measures].[Story Points created]

This formula will iterate through all issues and find the ones with no Story points to return a value of “3” for them. At the end, regular “Story Points created” measure can be added to count the Story points of issues that have them.

​Let me know if this fits your use case or if you have any additional questions on this!
​Best regards,
​Nauris