Can you post sample data of your two tables, at least in a spreadsheet, and ideally in a packaged workbook (.twbx) with data extracted?
To look into your question, we need to understand your data layout, and if you are joining or blending.
In filter ‘Result’ (2,0) has a result of Call Ids 8,10,12 and (1,1) has a value of only 8 and 10. So the behavior within the filter is normally OR (selecting both the filter results 8,10 and 12). But we need an AND operation within this dimension (selecting both should result only 8 and 10 since 12 is not evaluated in (1,1))
If Result table is in secondary datasource(blended), we need to achieve this scenario.
AndOpertion.twbx 15.7 KB