filter using combination of multiselect options from combo box

[pabitra]

There are 2 columns with multiple tests mapped to multiple packages.

I select distinct values of multiple tests in a combo box and want to select a package which consists of these multiple tests.

For distinct tests-

Sort(Distinct(Table1,Tests),Result)

For relevant packages-

Distinct(Filter(Table1,Tests in ComboBox1.SelectedItems.Result),Package)

But, the 2nd result gives me the package for last selection(not combination of multiple sleections in combo box)

How can i slelect a combination of all tests from 1st combo box and then select a package with all those tests.

FYI- Every package consists of 15-20 tests arranged in random order

Data is arranged as-

Package 1	Test 1
Package 1	Test 3
Package 1	Test 10
Package 1	Test 20
Package 1	Test 29
Package 1	Test 7
Package 1	Test 23
Package 1	Test 90
Package 1	Test 27
Package 2	Test 10
Package 3	Test 20
Package 4	Test 29
Package 5	Test 7
Package 6	Test 23
Package 7	Test 90
Package 8	Test 27

[PowerAddict]

Also, why would have the same test in the same package multiple times? This just seems like bad data to me, unless there is a reason for it. 

PackageTest

package01-01	test 4
package01-01	test 26
package01-01	test 26
package01-01	test 26

[pabitra]

Hi @PowerAddict ,

Apologies to upload it without cleaning.

To be specific, the packages are health packages which contain tests and vaccinations.

So, each package has a bunch of tests similar to some packages.

My task is to identify a/relevant packages which consist of input tests(mostly 5-10).

All these tests should be present in the package.

I was trying to split the logic to-

1. Identify relevant packages which contains input tests in combo box( which we have achieved)

2. Check if the output packages have all the tests mentioned

But, unable to implement it.

Thanks for your cooperation.

[pabitra]

Hi @PowerAddict ,

Any updated on the problem ?

I am waiting for your comment.

Thanks in advance.

[PowerAddict]

Will try it out tomorrow or latest on Friday