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- · Accepted solution]

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

[Cyber Tech Group]

This addressed my concern. Thank you very much!