I need help with mdx report

Questions & Answers
1

I need to count the number of unique tasks assigned to each sprint participant. For example: Task TOK-1 was assigned on users A, B and C.
And the TOK-2 task was assigned to A and B.
Then the metric value:
A - 2
B - 2
C - 1

2

Hi @EgorPolevoy , I am still learning EazyBi myself, but my try creating a new calculated measure as follows:

Count(
  Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    [Measures].[Issue Assignee] = [Assignee].CurrentMember.Name
  )
)

Cheers

Dave
3

Thanks but , not working

4

Hey there,

Do you have the Assignee Dimension at Rows and Issue Dimension at columns?

Maybe try this as a new calculated measure:

Aggregate(
  Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    [Measures].[Issues created] > 0
  )
)
5

Hi @EgorPolevoy ,
Welcome to the eazyBI Community :wave:

You can try using this formula to count how many issues were assigned to the user during the sprint. Use “Assignee” dimension on Rows and filter the report by the “Sprint” dimension in Pages:

NonZero(Count(
  Filter(
    DescendantsSet([Issue].CurrentHierarchyMember, [Issue].[Issue]),
    Aggregate({
      [Transition Field].[Assignee],
      [Transition Field].[Sprint status]
      },
      ([Measures].[Transitions to],
      [Sprint Status].[Active])
    )>0
  )
))

Here is the final report:

Count_issues_assigned
Count_issues_assigned1542×1118 145 KB

Kindly,
Gerda // support@eazybi.com