How do I dynamically count the number of months that have passed in a specific year using eazyBI?

Cyber Tech Group

I needed to see the average closed issues per month against the number of assignees.

Martins Vanags_eazyBI

Hi,

 

Try this formula in new calculated measure to return the distinct count of assignees for each period with closed issues.

 

Sum(
Filter(
DescendantsSet([Assignee].CurrentMember,[Assignee].[User]),
NOT [Assignee].CurrentMember IS [Assignee].[(unassigned)]
),
CASE WHEN
[Measures].[Issues resolved]>0
THEN
1
END
)

 

Martins / eazyBI