Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)]
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)]
Excellent, this worked. Many thanks!
yw