When using an expression as list box, field with values used as condition has those values selected

[datagrrl]

I have a conditional list box:

=if(Field1<10,Field2)

If I select values from this list box, the field with the conditional is also selected.

For example, if I select 31, for field 2, 2,3,5 are selected in Field1

But 31 in field 2 has more matches and I want to see all of those:

I read a post that implies I might be able to do this with set analysis, but I am struggling to write the set analysis.

[sunny_talwar]

Try this

Aggr(Only({<Field1 = {"<10"}>} Field2), Field2)

[sunny_talwar · Accepted solution]

Actually try this instead

=Aggr(Only({<Field1 = {"<10"}, Field2>} Field2), Field2)

[datagrrl]

Thanks, I was missing the Aggr part, that makes sense.