5 Replies Latest reply on Nov 6, 2013 6:39 AM by Matt Lutton

# Is it possible to use combined parameters for measure selection?

In my workbook I have several measures, such as pack sales and cash in USD. From those measures I have created several date calculated measures based on rolling 3 months, rolling 6 months, rolling 12 months and YTD.

So basically this means that there are following measures in the workbook:

Pack sales

Pack sales R3M

Pack sales R6M

Pack Sales R12M

Pack sales YTD

USD sales

USD sales R3M

USD sales R6M

USD sales R12M

USD sales YTD

Instead of using one parameter for the measure selection I would like to use two parameters, which would be combined. In one parameter I would have Pack sales and USD sales and in the other one I would like to have R3M, R6M, R12M and YTD. Is this possible?

Thanks,

Gorazd

• ###### 1. Re: Is it possible to use combined parameters for measure selection?

I don't see why not.  It just depends on what result you are looking for in your visualization.  When you say the parameters would be "combined", what do you mean?  How do you expect the two parameters to behave and affect the viz?

I'm just trying to clarify what your desired outcome is.

• ###### 2. Re: Is it possible to use combined parameters for measure selection?

So I would like to have 2 parameters. Values for the first one would be:

1. Pack sales

2. USD sales

The second parameter would have these values:

1. R3M (Rolling 3 months)

2. R6M (Rolling 6 months)

3. R12M (Rolling 12 months)

4. YTD (Year to Date)

The values of both parameters would be combined into one (e.g. Pack Sales YTD). This combined value is exactly the same as measure name in the workbook. So I would like to have the combined parameter affecting the choice of the measure.

• ###### 3. Re: Is it possible to use combined parameters for measure selection?

I believe you could do this, then.  You'd show the parameters and write a calc to leverage them.  An example might be:

IF [Parameter1]='Pack sales' AND [Parameter2]="R3M"

then [Pack sales R3M]

elseif [Parameter1]='Pack sales' AND [Parameter2]="R6M"

then [Pack sales R6M]

... etc, etc.

END

Will this work for your purposes?  I haven't tested.

• ###### 4. Re: Is it possible to use combined parameters for measure selection?

It works, I had to create a calculated field for the original Pack sales as you cannot mix agreggated an non-aggreated fields in calculated. Thanks a lot!!

• ###### 5. Re: Is it possible to use combined parameters for measure selection?

Not a problem, thanks for providing enough detail to provide a decent answer!  Usually we bark at you if you don't post a workbook, but this one was doable without it.  You dodged that bullet!

Cheers, and good luck.