dynamic dimension in an agrr function using variable issue

brunobertels — Fri, 08 Jul 2022 09:09:04 GMT

Hi Experts,

I'am strungling with a mesure using an agrr function aned a variable as dimension of the agrr

let's say i have created a variable "vJSM" button with 3 buttons for Day, Week and Month

and a variable vDimPeriod like this :

if($(vJSM)=1,
DATE,
if($(vJSM)=2,
[DATE_JOUR.autoCalendar.week],
if($(vJSM)=3,
[DATE_JOUR.autoCalendar.month])))

I would like now replace the dimension in this mesure with my variable vDimPeriod :

So rather than :

sum(aggr( sum( Volume) ,DATE))

sum(aggr( sum(Volume) ,[DATE_JOUR.autoCalendar.week]))

having this :

sum(aggr( sum(Volume) ,$(vDimPeriode)))

But this mesure does'nt work and i dont understand why ?

see below

Thanks in advance for your help

Re: dynamic dimension in an agrr function using variable issue

brunobertels — Tue, 12 Jul 2022 15:12:29 GMT

Just in case of same question I fixed my issue using this expression

I created a new variable vDimPeriode1 =

=pick($(vJSM),'DATE_JOUR','[DATE_JOUR.autoCalendar.SEMAINE]','[DATE_JOUR.autoCalendar.MOIS]')

and add this variable in my final mesure

sum(aggr( sum(Volume) ,$(vDimPeriode1)))

regards