Currently, DataItemTableFilter applies after joining two different data items. The work around is to make your filters occur upstream from your joins; however, queries do not support multiple data items in parallel levels. This means there is a functional gap if you have several data items with table filters involved.
I propose one of three solutions:
- [Recommended] Add a Data Item attribute that dictates if the DataItemTableFilter applies before or after the join.
- Default the DataItemTableFilter to occur before the SQL joining behavior.
- [Less recommended] Allow for multiple data items in the same tier.
Until one of these solutions is implemented, I have to run separate queries on similar data sets or scrap queries altogether.