Need yes or no based on two different columns

[Anonymous]

Hi,

I'm having a table with thousands of entries.By default I'm having ID, Item, Identity columns. If any one item has identity yes then all the item which belongs to that  perticular ID must have result yes and all the items has no then the result for that perticular id must be no. So, there are few Id's with only sigle items and others with multiple items. So, I need a fuction or DAX Code to get the output in Result column. Sample table is provided below. 

Please help me.

Thanks

ID	ITEM	Identity	Result
abcd	1	no	yes
abcd	2	yes	yes
abcd	3	no	yes
acb	1	no	no
acb	2	no	no
aec	1	no	no
ahg	3	yes	yes

[Greg_Deckler · Accepted solution]

Result Column =
IF("yes" IN SELECTCOLUMNS(FILTER('Table',[ID] = EARLIER([ID])),"Result",[Result]),"yes","no")

[Anonymous]

Thanks for your solution!!!!