Table 1 ( One ID can have One Level ) ID Level 1 level 1 2 level 2 3 level 1 4 level 3 5 level 1 6 level 3 Table 2 ( One Sub ID can have One Level ) Sub ID Sub Level 1 level 3 2 level 2 3 level 3 4 level 3 5 level 1 6 level 3 7 level 2 8 level 2 Table 1 and Table 2 have Active Relationship. After Relationship pulling all column in Table Visual looks like this ( One ID can have Multiple Sub ID ) ID Level Sub ID Sub Level 1 level 1 1 level 3 1 level 1 2 level 2 2 level 2 3 level 3 3 level 1 4 level 3 3 level 1 5 level 1 4 level 3 6 level 3 5 level 1 7 level 2 6 level 3 8 level 2 Question - Need to check Mismatch in LEVELS. A measure to check if same 'Level' exist in any of the 'Sub Level' for the same ID. For EX. ID = 1, has Level = Level 1 but 'Sub Level' doesn't have Level 1 ( then Mismatch) ID = 4, has Level = Level 3 but 'Sub Level' also have Level 1 ( then Match) Thanks in Advance
