My request to you will be to evaluate use of referencing if feasible.
Also I believe, community will be able to suggest better if you can furnish more details about your table structure such as if you have parent child relationship in your app between these tables etc.
It may be difficult to suggest exact or proper solution without knowing more details about the table structure and their relationship with each other…
In general, I believe, you may wrap your expression with ANY() if the SELECT() statement is likely to return only one value from the [Bags] or you may wish to make the Bags column in table 2 as Enumlist type or a VC depending on your app. structure and requirements.
ANY(SELECT(table 1[Bags],[Order ID]=[_THISROW].[Order ID]))