Find Distinct Data - Based On Two Columns

[rhcentennialh]

I have a database where I would like to identify unique codes that a particular person has not identified or coded. Below is an example of my problem.

Problem: I would like to exclude all of the codes "Name A" has identified/coded as well as the other "Names" for those identify codes, please see the data example below. 

Excluding just "Name A" codes is easy however i also want to remove the "Names" associated with Code 3 & Code 18 since they are also related to code "Name A" has identifed/captured.

Name	Code
Name G	1
Name C	1
Name G	2
Name F	2
Name B	2
Name G	3
Name F	3
Name A	3
Name A	4
Name A	5
Name A	6
Name A	7
Name B	8
Name B	9
Name F	10
Name B	10
Name F	11
Name G	12
Name A	13
Name D	14
Name G	15
Name D	15
Name C	16
Name A	17
Name G	18
Name A	18
Name B	18
Name H	19
Name G	19

[v-lid-msft · Accepted solution]

Hi @rhcentennialh ,

We use the following measure and get the expected result:

Not identified by Outside = 
IF (
    SELECTEDVALUE ( 'Table'[Code] )
        IN SELECTCOLUMNS ( FILTER ( ALLSELECTED ( 'Table' ), [Internal vs Outside] = "Internal" ), "c", [Code] ),
    BLANK (),
    "YES"
)

BTW, pbix as attached.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.