Default Filter not giving all results

[Ksenia1]

Hi all, I need help dealing with the default filter for one of my views.

I have two tables:

In table 1 I collect my projects:

and in table 2 I have an overview of a Project - Category combination:

I added a virtual column to the projects table to get the list of all categories for each project. Type: EnumList, App Formula:

UNIQUE(SELECT(Category[Category], [Project] = [_THISROW].[Project]))

Now, if I use the default filter to search for all Projects, which have the category A and B, I want my result to be Project 1, 2, 3 and 5.

But unfortunately, my result is only Project 1 (as the combination of A and B categories apply only to this project).

Is there a way how to achieve my wished behaviour in the default filter?

[TeeSee1]

Unfortunately that is the way the default filter behaves on list type columns…

You need to create your own filter if you want the functionality you want.

There are many examples and Q&As for Dashboards with dynamic filters..(here is one)

[Ksenia1]

How unfortunate

Thank you @TeeSee1 !