Hi,
i’ve got super simple dashboard with
- Issue Created,
- Issue Resolved and
- Backlog counted as:
Backlog:
Sum(
{
PreviousPeriods([Time].CurrentHierarchyMember),
[Time].CurrentHierarchyMember
},
[Measures].[crea-res])
[Measures].[crea-res]
[Measures].[Issues created]- [Measures].[Issues resolved]
I was asked to remove two issue types from chart so i tried two ways with Aggregate - Except and with Aggregate only for Issue Type Dimension but in both cases when Drilling through Issue in backlog (and onlu in backlog) I’ve got one of two errors:
I don’t really understand why error started to pop up when I add simple filter and why only on one of Measures. Maybe can you advice me other way to write these measures to make quality of performace higher.
Measures i wrote in Issue type dimension and tried to use in Pages: