Hi i am new to eazybi and trying to get open issues aged between 7 and 21 days and issues should be of Issue type ‘Service Request’ and ‘Incident’ so i created a calculated member under issue type
Issue Type Filtered -
Aggregate(
Except(
[Issue Type].[Issue Type].Members,
{ [Issue Type].[Bug],
[Issue Type].[Change],
[Issue Type].[Create a new user],
[Issue Type].[Problem],
[Issue Type].[Service Request with Approvals],
[Issue Type].[Task]}
))
Then trying to include in below calculated measure but it give no data to display as soon as i add condition
NonZero(Count(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
(
(
[Measures].[Open issues] > 0
AND
DateDiffDays(
[Measures].[Issue created date],
now()
) > 8
AND
DateDiffDays([Measures].[Issue created date],Now()
) < 22
AND
[Issue Type].DefaultMember IS ([Issue Type].[Issue Type Filter])
)))))
Please let me know where i am going wrong