topic Calculated dimension in set analysis? in App Development

Calculated dimension in set analysis?

cmc — Thu, 13 Apr 2023 13:45:24 GMT

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?

Re: Calculated dimension in set analysis?

edwin — Tue, 25 Apr 2023 15:28:43 GMT

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)]

Re: Calculated dimension in set analysis?

cmc — Tue, 25 Apr 2023 16:13:10 GMT

Excellent, this worked. Many thanks!

Re: Calculated dimension in set analysis?

edwin — Wed, 26 Apr 2023 12:21:46 GMT