Alternative to improve calculation performance

Hi experts,
Is there a way to improve the performance of the following calculated measure? Can this be done with a tuple to speed up the calculation time?

NonZero(
Avg(
Filter(
Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue])
,([Major Incident].[Major Incidents], [Measures].[Issue Time to Resolve created]) > 0
)
,([Major Incident].[Major Incidents], [Measures].[Issue Time to Resolve created])
)
)

My dashboard has several different reports like the following and they take quite some time to fully render
image

Hi @fabianmunoz
Thanks for posting your question!
One of the recommendations I can share is that when you build your formulas and use a filter function, is to filter by field properties.
You could try the formula below and see if it works faster for you?

NonZero(
  Avg(
    Filter(
      Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
      --filtering issues by prorperties will speed up the formula. Assuming that the property imported is "Time to Resolve"
      NOT IsEmpty([Measures].[Issue Time to Resolve]) AND
      [Measures].[Issue Major Incident] = "Major Incidents"
    ),
([Major Incident].[Major Incidents], 
[Measures].[Time to Resolve created])
)
)

Best wishes,

Elita from support@eazybi.com