Calculating Based on two custom values

Questions & Answers
1

I have a measure that is working fine that pulls values of a custom field is set to No

([Capitalization].[(none)] ,
[Measures].[Story Points resolved])

But I need to have two values checked - so something like

([Capitalization].[(none)] and [Capitalization].[No],
[Measures].[Story Points resolved])

But it is not working - any help appreciaed

2

Found the answer

(([Capitalization].[No] ,
[Measures].[Issues resolved])+ ([Capitalization].[(none)] ,
[Measures].[Issues resolved])) / [Measures].[Issues resolved]

1 Like
3

Hi Brian,

Yes, it is so that in Tuple you can reference each dimension only once. Besides what you thought of there is another workaround to create an Aggregate(…) calculated member in Capitalization dimension with name, e.g., “None and No” and following formula

Aggregate({
  [Capitalization].[(none)],
  [Capitalization].[No]
})

And then use this Capitalization member in the tuple

(
  [Measures].[Issues resolved],
  [Capitalization].[None and No]
)

Lauma / support@eazybi.com