Filter a column based on a value form another column

So you want to have it just showing those rows where column C is the same as column D? If so, just make a calculated column something like:

IsPreferredAddress = [Type] = [Person.PreferredAddresTypeId]

then filter that on true?

Anonymous 

I took some liberties with test data I used for this, but I think my solution might help. 

I have the following tables imported in my model:

Person:

Address:

After importing them into PBI, I used the following table expression to create a new table that pulled in the preferred address for each person:

 

SUMMARIZE Table = 
SUMMARIZE(
    Person,
    Person[Id],
    Person[Type],
    Person[Name],
    "Preferred Address",
    CALCULATE(
        SELECTCOLUMNS('Address',"Address",'Address'[Address]),
        FILTER(
            'Address',
            'Address'[Type] = Person[Type]
        )
    )
)

DAX with created table

 

Hope this helps!

Click HERE for the PBIX file.

CIick HERE for my address excel sheet.

Click HERE for my person excel sheet.