DAX increate a column grouping for a column and providing the data for other

[vzbkb1]

I am trying to create a new column in DAX that will give the result of the column Status for the type “Chain” with records with the same ID.  For example, for this table

Name	Type	ID	Status
a	Chain	21	Open
b	Job	21	Closed
c	Job	21	Closed
d	Job	21	Open
e	Chain	22	Closed
f	Job	22	Closed
g	Job	22	Closed
h	Job	22	Closed

The result will be

Name	Type	ID	Status	NewChain Status
a	Chain	21	Open	Open
b	Job	21	Closed	Open
c	Job	21	Closed	Open
d	Job	21	Open	Open
e	Chain	22	Closed	Closed
f	Job	22	Closed	Closed
g	Job	22	Closed	Closed
h	Job	22	Closed	Closed

Can you help me?

[vzbkb1]

Thanks a lot it works great 🙂

[tamerj1 · Accepted solution]

Hi @vzbkb1 
Please try

NewChain Status =
MAXX (
    FILTER (
        CALCULATETABLE ( TableName, ALLEXCEPT ( TableName, TableName[ID] ) ),
        TableName[Type] = "Chain"
    ),
    Chain[Status]
)