Finding if Multiple unique ID's share the same values across two columns

[Dominok123]

Hey,

So I'm trying to figure out how to create the fourth column 'ResultMatch' as seen in the table below. What I need this column to return is whether or not multiple ID's share the same 'Value1' and 'Value2' combination. So because ID 1 and 4 share the same Value 1 + Value 2 combination, 1 is returned, and for the ID's whose values don't match anyone else, they receive a 0.

Any help would be much appreciated.

Table1:

ID	Value1	Value2	ResultMatch
1	1000	350	1
1	1000	350	1
2	1200	600	0
2	1200	600	0
3	720	120	0
3	720	350	0
3	720	350	0
4	1000	350	1
4	1000	350	1

[Greg_Deckler · Accepted solution]

This should work as a column or measure:

Column = 
VAR __table = FILTER(ALL('Table6'),[Value1]=EARLIER([Value1]) && [Value2]=EARLIER([Value2]) && [ID]<>EARLIER([ID]))
VAR __count = COUNTROWS(__table)
RETURN
IF(ISBLANK(__count),0,1)