Please help if there is even one Yes related to one ID need Yes in all rows

[Anonymous]

Please help with below output , if there is even one Yes related to specific id need Yes in all the rows thank you in advance

ID	Col	Output
701	Yes	Yes
701	No	Yes
702	No	Yes
703	No	No
702	Yes	Yes
701	No	Yes

[amitchandak]

@Anonymous , Try a new column like

if(countx(filter(Table,[ID]= earlier([ID]) && [Col] ="Yes"),[Col])>0,"Yes","No")

[Ashish_Mathur · Accepted solution]

Hi,

This calculated column works

=if(CALCULATE(COUNTROWS(Data),FILTER(Data,Data[ID]=EARLIER(Data[ID])&&Data[Col]="Yes"))>0,"Yes","No")

Hope this helps.