Count number of Projects an Assignee have

VTP · September 19, 2018, 4:44pm

Hi,
Is there a way that I can find how many projects a certain ‘assignee’ have as ‘project specialist’?

daina.tupule · October 5, 2018, 8:18am

You can count Projects where an assignee have assigned issues.

NonZero(Count(
  Filter(
    [Project].[Project].Members,
    [Measures].[Issues created] > 0
  )
))

However, the calculation does not take into account user role in a project. eazyBI does not import project roles and related users by default.