Forum Discussion

adnanarain's avatar
adnanarain
Icon for Helper V rankHelper V
6 years ago
Solved

Need help with if condition Dax

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 t...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    adnanarain , Create a new column like

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

  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    @adnanarain - 

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

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

@adnanarain - 

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