EazyBI Formula is not valid error

TN Raju August 3, 2023

I am building a Average Age of Working Items in progress report. 

I have created the below Measures: 

 

While creating Total Work Item Age Measure using below formula & getting the error

Aggregate(
Filter(
[Issue].[Status].Members,
[Issue].CurrentMember.Name = "In Progress"
),
[Measures].[ Work Items Age in Days]
)

Please Suggest

2 answers

1 accepted

0 votes
Answer accepted
Gerda Grantiņa
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 7, 2023

Hi @TN Raju ,

If you want to filter your issues by some property and then calculate the average days, you need to use the DescendantsSet() function. 


Try this formula:

NonZero(Avg(
Filter(
DescendantsSet([Issue].CurrentHierarchyMember, [Issue].[Issue]),
[Measures].[Issue status] = "In Development"
AND
([Measures].[Transitions to status],
[Transition Status].[In Progress],
[Time].CurrentHierarchy.DefaultMember) > 0
),
[Measures].[Work Items Age in Days]
))

 

best,
Gerda

TN Raju August 8, 2023

Thanks. its worked.

Like Gerda Grantiņa likes this
0 votes
TN Raju September 14, 2023

.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events