Alternating expression

[liamlucas]

I want to create a master measure and use it in two different pivot tables.  If I am looking at  Pivot table 1 the first if statement will be active but if I am looking at Pivot table 2 the second if statement will be active.  I was thinking this might be possible if I referenced each pivot table object id.  Can you help?

If(Obj=ZQhUiW, [Liability] + [Equity],
If(Obj=BClJoL, [Revenue] - [Expenses]))

[Mauritz_SA]

Hi Liam

Why do you want to use the same master measure twice? Can't you just create two and give them different names and the same label?

Regards,

Mauritz