Hi Janis,
I got a similar question in my post Need calculate monthly issue resolve count, and the time/effort associated with the resolved issues
Could you help have a look?
I got the idea from this post and updated my calculation below, but still some results are not correct.
We use “engineer” in each issue to specify who resolved the issue, and allocate “original estimate hourse” on each issue. Now we need calculate, per each month, how many original estimate hours are resolved by each engineer.
Using the calculation below, some results are still not correct. Please kindly advise? Thanks!
Sum(
Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
[Measures].[Issues resolved]>0
),
([Measures].[Original estimated hours],
[Engineer].DefaultMember)
)