What does this error mean? I wrote some code for seeking certain tasks with a status of in progress

Failed to execute query. Error message:
OutOfMemory used=7731317264, max=8589934592

NonZero(Count(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
  [Measures].[Issues with Publish Date]>0 AND
    ([Measures].[Issue type] = "Sub-task") and 
  ([Measures].[Issue components] = "M2") and

  ([Measures].[Issue labels] = "chqa" OR [Measures].[Issue labels] = "noperfqa" or [Measures].[Issue labels] = "prodqa")AND
  ([Measures].[Issue status] = "In Progress") 
  
 ) 
))

Hi @irv45

Thanks for posting your question!

I would suggest using Sum instead of Count and using measure Issues with Publish Date as a numeric expression for the Sum function instead of filter criteria. With this approach, it will act both as a count and as a filter. The report with this formula should work faster.

Sum(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),   
    [Measures].[Issue type] = "Sub-task" and 
  [Measures].[Issue components] = "M2" and
  [Measures].[Issue status] = "In Progress"    
  ),
  CASE
  WHEN
  [Measures].[Issue labels] = "chqa" OR [Measures].[Issue labels] = "noperfqa" or [Measures].[Issue labels] = "prodqa"
  THEN 
  [Measures].[Issues with Publish Date]
  END
)

Best wishes,

Elita from support@eazybi.com