Aggregate issues with no sprint and status of request opened

I’m sure this is probably very simple but I can’t figure it out. I’m trying to get the TRUE backlog. Open Issues measure doesn’t do it in my instance.

I need to aggregate on both issues not assigned to a sprint [Sprint].[(no board)].[(no sprint)] and [Status].[Request Opened].

I’m assuming I have to somehow do a join to achieve this result, but I can’t get it to work. Appreciate the help!

Tried the following to no avail.

NonZero(count(Filter(Generate(NonEmptyCrossJoin(
[Sprint].[Sprint].Members, [Status].CurrentHierarchyMember),
[Sprint].CurrentMember),
[Measures].[Issue status] = ‘Request Opened’ AND
[Measures].[Issue Sprint Status] = ‘None’
)))

Hi,

Try this code with tuples instead:

 (
[Measures].[Issues created],
[Status].[Request Opened],
[Sprint].[(no board)].[(no sprint)]
)

It would return the number of all issues created (and imported in eazyBI) without any sprint from status “Request Opened” (current status).

Martins / eazyBI support