Skip to main content
MAINTENANCE ALERT: Dec. 12th starting 9 AM CET. Community will be read-only. GET DETAILS
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Using alternate state in condition for a calculated dimension

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!

1 Reply
Specialist III
Specialist III

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

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