Is there a way to set a condition to filter with measures?

[zane.baranovska]

Hi @Enjy_Essam,

Yes, you may write the calculated measure with several conditions on how to aggregate story points for a different issue type and other issue criteria. For conditions, you might want to use expression CASE WHEN … THEN … END. The formula might look like this:

CASE WHEN --issue has sub-tasks and is not a Task
  NOT IsEmpty([Measures].[Issue sub-task keys]) AND
  [Measures].[Issue type] <> "Task"
THEN
  Sum(
    --get sub-taks of an issue
    [Issue].[Issue].GetMembersByKeys(
      [Measures].[Issue sub-task keys]),
    --sum up SP of sub-tasks
    [Measures].[Story Points created] )
ELSE --for the rest of issues including Tasks and sub-tasks show assigned SP
  [Measures].[Story Points created]
END

If you like, you may update this expression and add more conditions WHEN … THEN. More details on the conditions are here: Calculated measures

Here is some conversation on related topics:

Sum of a numeric field in the sub-tasks of issue

Hello, I would like to sum for each issue some numeric field that exists in the sub-tasks of the issues. I tried something like this: Sum( [Issue].[Issue].GetmembersByKeys( [Issue].CurrentHierarchyMember.get(‘Sub-task keys’) ), [Issue.Sub-task].CurrentMember.get(‘Original Estimated Effort (Work Days)’) ) But it doesn’t work. Can you help please?

How to exclude sub-tasks story points from the story point completed?

Hello ! I want to calculate how many points by sprint my teams commited and delivered, but without story points that are evaluate in the sub-tasks. For example my team commited to 16 points in the parent issue, and splitted those 16 points in the sub-tasks. The total with the classical Sprint Velocity chart in EazyBI will be 32, because it is based on story point commited >0, instead of 16 (sprint report in JIRA excluse subtask’s story point). So how to exclude sub-tasks story points from the…

Best,
Zane / spport@eazyBI.com