Calculated dimension in set analysis?

[cmc]

I have three binary dimension columns, each one selected by a user via a variable drop down. Then the value of the variable is used to select the intended dimension via a calculated master dimension.

It seems like it's still not possible to use this calculated dimension in a measure that uses set analysis. Are there any good work arounds for my use case?

[edwin · Accepted solution]

from what i understand, you have 3 variables and from that you are able to derive a field name.  i suggest you store the field name as a variable (you can actually have it separate from your master dim or create your master dim from the variable)

then you use 

[$(variableHere)]

anywhere you want it as a field -

you can use it in set analysis

sum({<[$(variableHere)]={'xxx'}>}yyy)

or a master dimension

[$(variableHere)]

[cmc]

Excellent, this worked. Many thanks!

[edwin]

yw