Filter - "CONTAINS" filter on column <calculated field>

[baduong]

Hi team,

I got an weird error when with parameter.

I have a field in the dataset named “period”. I created a parameter named [PPeriod1] with drop down list to allow users select multiple values for this field.

I have a calculated field named [cf_Period1] with the formula:

ifelse(in({period},${PPeriod1}),‘Compare From’,‘’)

After I created the calculated field, the control (placed inside sheet) of the parameter showing this error:

---

Following items are incompatible with Multi-select drop down. Please update/remove them to fix the broken visuals.

Filter - “CONTAINS” filter on column cf_Period1

---

Any way I could fix it?

Noted that when bring the control up to filter area, it’s still allowed to choose the filter but has a red ! beside.

[andrepgn]

Hi @baduong ,

can you show us how the param and the control are configured?

Have you tried to directly link the possible value of the multi-select control to the dataset, or have you entered the data manually?

Thank you,

Andrea

[baduong]

@andrepgn

Have you tried to directly link the possible value of the multi-select control to the dataset, or have you entered the data manually?

Hi, sorry for the delay. Here is the configuration

[baduong]

Hi team, any update on this?

[andrepgn]

Hi @baduong ,
do you have any other filters in the same dashboard? Or calculated fields?
Any other “not standard” config? Just to try and replicate the issue

Andrea

[baduong]

Hi, there is nothing not standard.

[Brett]

Hi @baduong,

Following up here as it’s been awhile since last communication took place on this thread; are you still working on this or were you able to find a work around in the interim?

To my understanding, the ‘CONTAINS’ logic does not work with a multi-select parameter, you’ll have to use ‘INCLUDES’ instead. This will have the same affect as ‘contains’ in your instance.

Let us know if you have any additional questions, if we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you

[baduong]

Hi,

The thing is in the formula, it doesn’t have CONTAIN function. Its content:

ifelse(in({period},${PPeriod1}),‘Compare From’,‘’)

[Giridhar.Prabhu]

Hi @baduong

The issue appears from the filter on the visual. There is a old post with similar issue see if it helps

Multi-select dropdown parameter doesn't allow CONTAINS filter

The error message you’re encountering indicates that the multi-select dropdown controls you’ve enabled are not compatible with the “CONTAINS” filter applied on the column KPI_SUB in your visuals. It seems that the filter is causing conflicts with the multi-select functionality. To resolve this issue, you can consider an alternative approach for filtering based on the KPI_SUB column. Instead of using a “CONTAINS” filter, you can try using a different filter type that is compatible with multi-sel…