Need help with if condition Dax

[adnanarain]

I want to add calculated column, if the same serial number contains any fail value in status column then calculated column should be equal to NO, no matter how many pass values are there.  Below is the my data model.

serialnumber	status	Right First Time
JAA20H1700093	Pass	No
JAA20H1700093	Pass	No
JAA20H1700093	Fail	No

[amitchandak · Accepted solution]

@adnanarain , Create a new column like

if( countx(filter(table,[serialnumber] =earlier([serialnumber]) && [status] ="Fail"),[serialnumber])+0>=1, "No","Yes")

[Greg_Deckler · Accepted solution]

@adnanarain -

Right First Time =
  IF(COUNTROWS(FILTER(ALL('Table'),[serialnumber]=EARLIER([serialnumber]) && [status]="Fail"))>=1,"No","Yes")

[amitchandak · Accepted solution]

@adnanarain , Create a new column like

if( countx(filter(table,[serialnumber] =earlier([serialnumber]) && [status] ="Fail"),[serialnumber])+0>=1, "No","Yes")