Master measures

[She1]

Can one master measures be used in other master measures. I tried to use it but the expression editor doesn't seem to quite recognize it. Any help around this would be appreciated!

Sum(
{<recruitment_stage = {'ACTIVE'}>}
revenue_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
employee_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
data_analytics_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
existing_partnerships_ana_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
existing_partnerships_auto_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
other_partnership_DA_score)

The one in blue is the master measure I am trying to use in this one.

[ggijben · Accepted solution]

Hi @She1, 

You unfortunately can't perform Set Analysis over a master measure. You can re-use them, but only on the highest level.

So for example:

Master item 1:     Revenue = SUM(Revenue)
Master Item 2:     Costs = SUM(Costs)

You can then do:
Master Item 3:     Margin = Revenue - Costs.

But if you want to use set analysis in the Revenue masteritem, you need to build it again from scratch like :

Revenue2 = SUM( {< recruitment_stage = {'ACTIVE'} >}Revenue).

Then use Revenue2 in your future measures.

[She1]

Thank you so much! It exactly worked the way you have shown.