# Timeout caused by a measure

**URL:** <https://community.eazybi.com/t/timeout-caused-by-a-measure/11438>\
**Category:** Questions & Answers\
**Created:** [January 11, 2023, 8:23am UTC](https://community.eazybi.com/t/timeout-caused-by-a-measure/11438 "2023-01-11T08:23:29Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![scontu](https://community.eazybi.com/letter_avatar_proxy/v4/letter/s/e95f7d/32.png) [@scontu](https://community.eazybi.com/u/scontu)\
**Post date:** [January 11, 2023, 8:23am UTC](https://community.eazybi.com/t/timeout-caused-by-a-measure/11438/1 "2023-01-11T08:23:29Z")

</div>

Hello  
I am receiving timeout when trying to execute this measure (there is also a filter by board)

– days in transition status when issue was in this status in previous times

```auto
[Measures].[Days in transition status]
+
-- days since last transition to this status
NonZero(SUM(Filter(
  Descendants([Time].CurrentMember,[Time].[Day]),
  -- for unresovled issues only
  IsEmpty([Issue].CurrentHierarchyMember.Get("Closed at"))
  AND
  [Measures].[Issue status] = "Blocked"
  ),
  CASE WHEN
  [Measures].[Issues history] > 0
  THEN
  DateDiffDays(
    [Measures].[Issue status updated date],
    Now()
  )
  END
))

```

is there any way to optimize it?  
thanks a lot

---

<div class="post-metadata">

**Author:** ![gerda.grantina](https://community.eazybi.com/user_avatar/community.eazybi.com/gerda.grantina/32/1994_2.png) [@gerda.grantina](https://community.eazybi.com/u/gerda.grantina)\
**Post date:** [January 16, 2023, 2:58pm UTC](https://community.eazybi.com/t/timeout-caused-by-a-measure/11438/2 "2023-01-16T14:58:28Z")

</div>

Hi @scontu,  
from the formula, it seems that you want to sum Issue days in the selected status till now. In that case, I suggest using the measure “Days in transition status till now” from this report: [Issue days in selected status - Issues - Jira Demo - eazyBI](https://eazybi.com/accounts/1000/cubes/Issues/reports/61947-issue-days-in-selected-status)  
And filter by dimension “Transition Status” value “Blocked”.

Your formula gets timeout because you are iterating through the “Time” dimension “Day” level (with function [Descendants()](https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/descendants) and [Time].[Day] it can cause performance problems), plus you are filtering days by issue properties although the Issue dimension is not used in your formula.

kind regards,  
Gerda // [support@eazyBI.com](mailto:support@eazyBI.com)
