Show all grouped that meets all filter criteria

[NIVA]

Hello to all helpful people 🙂

I have a table that looks like this:

I now have two slice filters, once for all AP00XXX names and once for all EXT0XXX.

All these names are available in groups. I have divided the groups with the red lines.

I would like to find out in which group the filtered names are present. The combination of the names is always unique.

If I now enter AP00201, AP00307 and AP00404 in the filter all groups should remain from the picture.

Group two has exactly these entries, but all other groups have these entries and more.

Unfortunately, the slicer doesn't work that way.
If nothing is filtered everything looks great. There is the group and all names within the group.

As soon as I choose a name in the slicer it shows me the groups in which the name exists, but only the one name. I don't see all entries in this group anymore and it shows me all groups that have at least one of the selected names.

To cut a long story short. I need a filter where I can select several entries and it checks if at least all these entries are available in a group. In the list of results I see the group and ALL entries that exist in this group.

So if I make the same selection as described above it would show me all groups with all entries on the picture above. If I now additionally enter EXT01010 he only shows me group 4 and everyone else is gone.

Does anyone have any idea how I can best implement this?

[v-chuncz-msft]

@NIVA,

You may try adding a measure and drag it to Visual level filters.

[NIVA]

@v-chuncz-msft

Thanks for your help.

I took a look but I don't think I can achieve my goal.

Is there a way (perhaps by code) to check what the user has selected in the slicer?

Then I can use this information to filter another object.

[NIVA]

Is it possible to give the slicer an "and" to combine several things to search for?