I got a similar problem and seems like the “Open issues” is not accurate. The default calculation “Open issues” measures issue created - issue resolved.
Now I used the similar calculation for “submitted yet unresolved” to measure issues submitted - issues resolved… in calculation below
For Apr now it shows 80 – but if I drill into Apr it shows today latest number is 83, not sure why it is showing 80 in the calculation.
And… the accurate number today is actually 82.
Please help let me know what went wrong… maybe this is not the proper calculation for me… what I need is the total number of issues in certain status by end of each month or by end of today (the current month). Please kindly advise. Thanks!
CASE WHEN [Issue].CurrentMember.Level.Name <> ‘Issue’
AND [Measures].[Issues created]>0
- [Measures].[Issues resolved])
+ [Measures].[Issues submitted]
- [Measures].[Issues resolved]
WHEN [Time].CurrentHierarchyMember IS [Time].CurrentHierarchy.DefaultMember
THEN NonZero([Measures].[Issues due])
– optimized formula for drill through Issue