interesting problem. i want to find everything in table A that’s not in a filtered version of table B, all focused on the common column “userid”.
both are multi-column tables, with different numbers of columns so we’ll need to use “distinct”.
normally i’d just do an “=except(distinct(TableA[userid], TableB[userid})”, but the twist is that I only want to include the table B userids with “resource type” equaling “Mgmt”.
I can create a new version of Table B with just the “Mgmt” resource types, but is there a way to do it all in one formula without the intermediate table?
Table A includes userids a123,c123, e123, f123, and g123.
Table B includes b123, c123, d123, and e123, but only c123 and e123 are “Mgmt”.
The “except” comparison should result in a123, c123, e123, f123, and g123.
Table B’s b123 and d123 are excluded because they don’t have resource type “Mgmt”.
Thanks for your help.Sample File.pbix (47.3 KB)