Check if duplicated unique value has mismatched values in other columns

[zahidah_mabd]

Hi, 

I have two columns [Position ID] and [Position Location] in the table 'Position'.

There are some duplicates on the position ID. 

I have created a column to count the duplicates for position ID
Duplicated Position_Code = 
Var Position_ID = [Position ID]
RETURN

CALCULATE(
COUNTROWS('Position'),
all('Position'),
'Position'[Position ID] = Position_ID
)

The output will show the number of times the Position ID is in the data.

So now I want to check if the duplicated position ID has the same location for each data or not.

This is an example of duplicated position ID data with multiple locations.

Position ID	Position Location	Duplicated Position_ID
1130	New York	3
1130	New York	3
1130	Ohio	3
1456	Nashville	2
1456	Boston	2

So basically the duplicated ID would be

Duplicated Position_ID <> 1

But im not sure how to get that measure.
Can anyone help me with this? 

[ryan_mayu · Accepted solution]

@zahidah_mabd 

is this what you want?

Column = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Position ID]=EARLIER('Table'[Position ID])&&'Table'[Position Location]=EARLIER('Table'[Position Location])))

[zahidah_mabd]

It wasnt what I was looking for at first, but I did find it useful and managed to  get the output that I want from your solution. Thank youuuu

[ryan_mayu]

you are welcome