if under the same value in one column the values are the same in another column

[123117]

if under the same value in one column the values are the same in another column 

This is what my table looks like: 

code	code2	country
1234	8945	USA
1234	8944	France
2345	3666	Canada
5678	7654	Africa
5678	7655	Africa

I have codes and their respective countries, I want to check if the same codes have same countries and if not then I wanna flag those codes, codes can repeat by codes2 wont. Code2 can have same codes 

eg: 1234 has two countries; USA and France so I need to flag that but 5678 has the same so it's fine. 

desired output: 

code	code2	country	Indicator
1234	8945	USA	Different
1234	8944	France	Different
2345	3666	Canada	OK
5678	7654	Africa	OK
5678	7655	Africa	OK

Please help

[Samarth_18 · Accepted solution]

Hi @123117 ,

You can try this:-

Indicator =
VAR result =
    COUNTROWS (
        FILTER (
            'Table',
            'Table'[code] = EARLIER ( 'Table'[code] )
                && 'Table'[country] <> EARLIER ( 'Table'[country] )
        )
    )
RETURN
    IF ( ISBLANK ( result ), "Ok", "Different" )

Thanks,

Samarth

[123117]

Hi

thanks!

I'm trying and I'm getting this error

EARLIER/EARLIEST refers to an earlier row context which doesn't exist.

[Samarth_18]

@123117 Please create a column instead of measure.

[123117]

this works! thnx