The calculated measure returns the same result because all calculation elements ignore the current Time dimension member. The issue property ācreated at with timeā is not tied to the Time dimension, and the āfirst assignee dateā references the Time dimension default member.
Also, I donāt recommend iterating through the Issue dimension āIssueā level members with the particular expression. Instead, use the Descendants() function and use an issue property as the first filter condition, a numeric measure to tie the calculation to the report context.
Suppose you want to tie the result to the issue creation date on the Time dimension. In that case, the calculated measure formula would look similar to the one below:
Avg(
Filter(
Descendants([Issue].CurrentMember,[Issue].[Issue]),
-- issue created in Time dimension period
DateInPeriod(
[Issue].CurrentMember.Get('Created at'),
[Time].CurrentHierarchyMember
)
),
CASE WHEN
-- issue assignee has changed
([Measures].[Transitions from assignee],
[Time].CurrentHierarchy.DefaultMember) > 0
THEN
[Measures].[dead time]
END
)
Please look at our documentation page for more information on defining calculated measures - āCalculated measures and members.