Using alternate state in condition for a calculated dimension

[zwilson_borg]

I need to use an alternate state's value of a field in the if statement condition of a calculated dimension. I've tried using combinations of sum, aggr, and only and haven't had much success. The basic idea of what I'm trying to do is if([Hierachy]='Division', [Division],[Unit]) - however, the [Hierarchy] is selected in a different alternate state than what the chart is being created against. 

Thank you in advance for your help!

[jwjackso]

Use the Concat function, it will return a string of selections from the Hierarchy dimension.

if (Concat({AlternateStateName}[Hierarchy]) = 'Division',[Division],[Unit])