Filtering a list using values from other table

[Guille]

Hello. I’m a little stuck with filtering a list.

I have a data table “A” whit only two column Key (ID) and Name. Further I have other data table B where it’s posible to relate each entry from data table A whit other entries from the data table A with three columns:
Key (ID)
Name (Data from table A)
Son Name (Data from table A)

I wish to filter the data in the form for data table B for the Son Name column. I need to show only the values from data table A, that alredy have not related whit the Name select in the form in data table B.

Thanks in advance.
Guille.

[Steve]

Try this:

(
  table A[Son Name]
  - SELECT(
    table A[Son Name],
    ([_THISROW].[Name] = [Name])
  )
)

[Guille · Accepted solution]

Thanks for your time and your response Steve. I apreciate it so much.

I have been proving your solution, but it doesn´t work. Edit: It’s works!!! Thanks so so so much! At the end of this response I paste the final formula that I finally use, for the community. Also my re explanation of the problem for if people wants more info.

Table A has no a column Son Name. Just ID and Name.
Is in Table B where I relate the IDs from Table A in this way: ID / Name (ref column from Table A) / Son Name (ref column from Table A).

My tarjet is the follow:

Table A:
Row1 ID 00001 Name Label1
Row2 ID 00002 Name Label2
Row3 ID 00003 Name Label3
Row4 ID 00004 Name Label4

Table B:

Row1 ID 0000A Name Label1 Soon Name: Label2
Row2 ID 0000B Name Label1 Soon Name: Label3
Row3 ID 0000C Name Label3 Soon Name: Label2

Whit this data, if I create a new entry in Table B:

ID: UNIQUEID ()
Name: Complete list of Keys from Table A. For example: 00001 (Label1)
Son Name: Complete list of Keys from Table A, minus values from Table A alredy related whit value selected in column Name in Table B. This example: Label1 and Label4, but no Label2 or Label3.

Thanks in advance.
Guille.

Edit: Solution:

Table A [ID]

-SELECT(
Table B [Son Name],
([_THISROW].[Name] = [Name])
)