How to find stories without sub-task

Hi,

I would like to add a column(Stories without Sub-task ) in my report. Could you help me with logic.I tried this formula but it dose not work.

Aggregate(
Filter(
  [Issue type].[Story],
  NOT [Issue type].CurrentMember.GetBoolean('Subtask')
  ))

Hi @Dipesh_Chouksey

eazyBI does not have any predefined measure that would show how many issues have subtasks, but there is property “Issue sub-task keys” holding a list of subtasks for each issue.
You might want to construct the calcaution using functions Filter() and DescendantsSet() to iterate through individual issues and check them by specific criteria; then Sum() them up if they pass conditions.

The expression to get the count of Stories with sub-tasks might look like this:

NonZero(Sum(
  --iterate through individual issues with type Story
  Filter(
    DescendantsSet([Issue].CurrentMember,[Issue].[Issue]),
    [Measures].[Issue type] = 'Story' AND
    --check if story has any linked subtask
    NOT IsEmpty([Measures].[Issue sub-task keys])
  ),
  --sum up stories matching the repost of report context
  ([Measures].[Issues created count],
  [Issue Type].[Story])
))

Please read the documentation page on calculated measures, how to build them, and what are the main rules for each calculation: Calculated measures.

Best,
Zane / support@eazyBI.com