Calculated Measure under Project Dimension Using Other Dimension

Questions & Answers
1

Can I created a calculated measure under the project dimension to filter based on other dimension?

Aggregate({[Project].[Dev Project Name] where [Issue Type] = “Generic Time” and [Time Class] = “Absence” is the general desire. If it’s possible, what would the syntax be? I’ve searched and couldn’t find a way to do it.

2

Hi @Shel_Price

We do not recommend creating a calculated member in a specific dimension and using other dimensions in the calculation. For example, a custom-defined member for the Project dimension should define a Project member based only on the data in the Project dimension (respective table in the database).

Any such linkage between different dimensions should only be made through measures in the Measures dimension.
If you have the custom field [Time Class] imported as a dimension, you can define a new calculated measure in the Measures dimension with the following tuple in the formula:

(
  [Measures].[Issues created],
  [Project].[Dev Project Name],
  [Issue Type].[Generic Time],
  [Time Class].[Absence]
)

This will return the number of Issues created corresponding to the selections, but you can replace this measure with whichever is necessary for your use case.

You could also achieve this by using the Issue Type and Time Class dimensions in Pages to filter by necessary selections.

Let me know if this fits your use case!
Best regards,
Nauris / eazyBI support