Issue for multi-value parameter with Select All option

Question & Answer
, , ,
1

Hi All,
I have multi-value parameter control and using that parameter within calculated field as below :
(Bold one is parameter - ${Factors})

ifelse(in(factor,${Factors}),{Sales},NULL)

So whatever factor name we will select from parameter control, We should get Sales for those selected factors. However for select all selection from factor parameter, Its giving else part from above calculations. Expected output is to get sales for all factors.

Can someone please assist on this or provide any suggestions?

Note : We have two measure, One is profit which will be potted by default and there won,t be any impact on it for this factor parameter control. Adjutant bar for Sales which will work and filter data on basis of factor parameter control selection.

Let me know in case any more info required on this.

Thanks…!

2

Hi @vaibhavt ,

I got the same Issue. Solution I found was to reset the dropdown (see picture below).

image

Best Regards,
Nico

error

3 Likes
3

Hi @vaibhavt,
It’s been awhile since we have heard from you. Are you still having problems with your question or did the solution provided above work for your needs?

If we do not hear back in 3 days, I will go ahead mark the the prior comment as the solution but still feel free to let me know if you have any follow up questions.

Thank you!