variabilisation of dimension

Michaels — Fri, 18 Dec 2020 11:58:19 GMT

Hello,

I have some dimensions : Product1, Product2, Product3, ...I'm using those dimensions in set analysis

I have a filter to select the numero of the product (1, 2, 3 ...)

Is it possible to set a variable to determine the dimension ?

Equivalent to :

if(getfieldselection(value) = 1, sum({<Product1={something}>} measure),

if(getfieldselection(value) = 2, sum({<Product2={something}>} measure),

if(getfieldselection(value) = 3, sum({<Product3={something}>} measure),

))))

I would like something like :

myvariable = 'Product'&getfieldselection(value)

to do sum({<myvariable={something}>} measure),

Re: variabilisation of dimension

Anil_Babu_Samineni — Fri, 25 Dec 2020 21:16:15 GMT

Perhaps this

sum({<YourKey={"=$(myvariable)=something"}>} measure)