Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
Hi @vzbkb1
Please try
NewChain Status =
MAXX (
FILTER (
CALCULATETABLE ( TableName, ALLEXCEPT ( TableName, TableName[ID] ) ),
TableName[Type] = "Chain"
),
Chain[Status]
)
Thanks a lot it works great 🙂
Hi @vzbkb1
Please try
NewChain Status =
MAXX (
FILTER (
CALCULATETABLE ( TableName, ALLEXCEPT ( TableName, TableName[ID] ) ),
TableName[Type] = "Chain"
),
Chain[Status]
)
User | Count |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
81 | |
55 | |
39 | |
20 | |
12 |