How to optimize a measurement

Questions & Answers
1

Hi,
how can i optimize the measurement below to run faster?
(my measurement is intended to find all issues that have either of this label. if it has both, count it once)
I prefer not to use javascript as i have several cases for these labels and rather not spend time updating the javascript every few weeks. but if this is the only way, can you help me with the syntax?

NonZero(
sum(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
CoalesceEmpty([Measures].[Issue labels], “”) MATCHES “.rel_blocker_x.”
or
CoalesceEmpty([Measures].[Issue labels], “”) MATCHES “.rel_blocker_y.”
),
[Measures].[Issues created count]
))

–minus. did not find a way to format it to appear as a minus sign
“-”

NonZero(
sum(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
CoalesceEmpty([Measures].[Issue labels], “”) MATCHES “.rel_blocker_x.”
AND
CoalesceEmpty([Measures].[Issue labels], “”) MATCHES “.rel_blocker_y.”
),
[Measures].[Issues created count]
))

2

Hi @meravbe

You could try this formula for your calculated measure

Aggregate({
[Label].[rel_blocker_x],
[Label].[rel_blocker_y]
},
[Measures].[Issues created count]
)

Martins / eazyBI support