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

[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:

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



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
AUG Leaders

Atlassian Community Events