Toggle between Filterpane/Expression dimensions using Pick/ Match

[vkish16161]

All,

I have a question.

We have a Value_Selector field in the DM with these 3 values 'A','B','C'.

We also have 3 separate flags in the DM named 'A','B','C'. The values for these flags are 0 and 1 only.

We have an expression of the form

Sum(Sales * if(Value_Selector='A',,

                       if(Value_Selector='B',,

                           if(Value_Selector='C',, ))))

Can I use a Pick/Match for this?

BIG Caveat: What if the user selects multiple values. (Like A and B or All of them)

cleveranjos‌ swuehl‌

[vkish16161]

ALL, just an update.

I used this and it looks like it works, but only in a filterpane. I still can't get the expression to work properly.

(pick

(Alt(match([Area Universe],'DSP','PC','AC'),'4'),[DSP Flag],[PC Flag],[AC Flag],[AC Flag])

)

P.S for the caveat - I have simply used the Alt function.

[sunny_talwar · Accepted solution]

How about this?

Sum(Sales * $(=If(GetSelectedCount([Area Universe]) = 1, '[' & [Area Universe] & ' Flag]', '[AC Flag]')))

[vkish16161]

Good solution as usual Sunny. Will try this out.

Thanks for the help.