Measures calculated and Several Dimension

Questions & Answers
,
1

Hello

I have Formulas to calculated Measures From a Measure “Original Estimated hours”

([Measures].[Original estimated hours],
[Time].CurrentHierarchy.DefaultMember)/8

([Measures].[Original estimated hours],
[Sprint].CurrentHierarchy.DefaultMember)/8

I would do only one formula with All dimensions conditions.

How i can do it ? Thanks by advance for you avance

Best regards

Jerome

2

Hi, @Jerome_Arpin

You can use all the dimensions (only once) in the tuple.

It is possible to include both dimensions in the tuple. See the formula below:

([Measures].[Original estimated hours],
[Time].CurrentHierarchy.DefaultMember,
[Sprint].CurrentHierarchy.DefaultMember)/8

Kindly,
Ilze support@eazybi.com

1 Like