You can try out this formula to calculate an Average of time is open from creation date till today or in how many days issue were resolved for any created issue in a selected period:
NonZero(AVG(
Filter(
Descendants([Issue].CurrentMember,[Issue].[Issue]),
[Measures].[Issues created] > 0),
CASE
WHEN NOT IsEmpty([Measures].[Issue resolution date]) THEN
DateDiffWorkdays(
[Measures].[Issue created date],
[Measures].[Issue resolution date]
)
ELSE
DateDiffWorkdays(
[Measures].[Issue created date],
Now()
)
END
)
)
If you would like to see this value cumulatively for any period, you can check the measure Average days till resolution or period end in example Average age till resolution report in our demo account.
In the formula example, I used an aggregator AVG. You can use any other, for example, Sum, Min, Max, etc., that matches the expression and gives a numeric value as a result.
Function(set, numeric_value)