Formula writing

[mmoroni]

I know sample data is best, and if need be, i can create something.  BUT - 
[Status]  [Address]
Active - 123 Main St
Inactive - 123 Main St
Inactive - 456 Main St

Looking for a formula that if the Address column of that row sees ANY line that has "active" in the status column, it reports back active; if not, it can state "inactive.

So, a new column would show
Active

Active

Inactive

[AlexisOlson · Accepted solution]

Try this:

IsActive =
IF (
    "Active"
        IN CALCULATETABLE (
            VALUES ( Table1[Status] ),
            ALLEXCEPT ( Table1, Table1[Address] )
        ),
    "Active",
    "Inactive"
)

[mmoroni]

This was exactly what I needed!  I love this community!  Thank you!