Performance issue when calculating Max with filter and descendants

Questions & Answers
2

Hi,

The following formula is for efficient processing of the issues from the specific project and taking the maximum of the measure:

   MAX(
      [Issue].[abc].Children,
CASE WHEN [Measures].[Issues created]>0
THEN
      [Measures].[Avg memory numeric]
END
)

Note to check the correct name of the project in the second line of the code.

Kindly,
Janis, eazyBI support