Help with MDX Measure for Avatar: Standard Sub-task in EazyBI

[Gopinath Kumaravel]

Hello Everyone,

I need assistance creating a custom measure in EazyBI for my report. Specifically, I want to identify and calculate the Start Date for issues that meet the following conditions:

• The issue is a Sub-task.
• The Task Type (Custom Field) of the issue is Avatar (Option).

To achieve this, I configured the following MDX formula and it is not generation the values in the report

CASE    WHEN [Issue.Sub-task].CurrentHierarchyMember.Get('Issue Type') = "Sub-task"    AND [Issue.Sub-task].CurrentHierarchyMember.Get('Task Type') = "Avatar"    THEN [Measures].[Issue Start date]END

However, I am unsure if this is the correct approach or if there are better ways to achieve this in EazyBI. Could you please help me with the following:

1. Review the MDX formula and suggest any corrections or optimizations.
2. Confirm if this formula will work for identifying issues with the specified conditions.
3. Provide guidance if additional configurations are needed to make this work in EazyBI.

Any help or suggestions would be greatly appreciated! Thank you in advance for your support.

Best Regards,

[Nauris Malitis -eazyBI-]

Hi @Gopinath Kumaravel 

You're on the right path! The only thing here is that the Issues don't have a property "Issue Type", they have "Issue Type ID" instead. We've converted this with the [Measures].[Issue type] measure.

When you import custom fields as properties, eazyBI generates a measure in the measures dimension that references the property, so you should be able to use a formula like this:

CASE WHEN
  [Measures].[Issue type] = "Sub-task"
  AND
  [Measures].[Issue Task Type] = "Avatar"
THEN
  [Measures].[Issue Start date]
END

Note that Issue properties return values only when the issues themselves are in the report context, for example, in the rows.

Let me know if this works as expected or if you have any additional questions!

​Best regards,

​Nauris / eazyBI support