Forum Discussion
Need conditional Flag - Parent Child Relation
I'm looking a DAX column Flag that checks for this condition.
If Parent P1 is from IND then corresponding all the childrens for the Parent should be from same country. Any other country then it should be highlighted as Issue.
| Parent | Country | Child | Country_Child | Flag_Required |
| P1 | IND | C1 | IND | No Issue |
| P1 | IND | C2 | US | Issue |
| P1 | IND | C3 | IND | No Issue |
| P2 | US | C4 | US | No Issue |
| P2 | US | C5 | IND | Issue |
| P3 | UK | C6 | UK | No Issue |
2 Replies
- amitchandak
Super User
Technically first columns of parent details are present in different table and child table different with Parent id common in both tables.
