IF contains in a group, return value

[Mimi_Ibrahim]

Hi Team, 

Can someone help me with a measure that will show as Result in below table please?

The condition is, if Group 2 contains X, then the Result = Red be applied to the whole row based on Group 1, else Result = Green.

Any help is much appreciated! Thank you!.

Group 1	Group 2	Result
Malaysia	1	Green
Malaysia	1	Green
Malaysia	1	Green
Singapore	1	Red
Singapore	X	Red
Singapore	1	Red
Singapore	X	Red
Thailand	1	Red
Thailand	X	Red
Thailand	1	Red

[Sahir_Maharaj · Accepted solution]

Hello @Mimi_Ibrahim,

Can you please try this:

Result Measure = 
VAR CurrentGroup1 = MAX('Table'[Group 1])
VAR IsXInGroup = CALCULATE(
    CONTAINS('Table', 'Table'[Group 2], "X"),
    ALL('Table'),
    'Table'[Group 1] = CurrentGroup1
)
RETURN
IF(IsXInGroup, "Red", "Green")

[Mimi_Ibrahim]

Works like a charm! Thank you Sahir!