Need Custom Column by existing column

[MuraliPrasath]

Hi, 
I need to create a new column called Final Pass/Fail. The logic should be: if a TitleNo value appears more than once, and at least one of its corresponding rows in the Pass/Fail column is Pass, then all rows with that TitleNo should be marked as Pass in the new column. Otherwise, mark them as Fail.

Could you help me on this? Thanks!

[Vegar]

You could try something like this:

If (count(total <[Title no]> [Title no])>1, 'Pass','Fail')

[Amit_Prajapati · Accepted solution]

Hi, You can try with below one.

If (count(total <[Title no]> [Title no])>1 and Pass/Fail='Pass', 'Pass','Fail') or

if (aggr( count(Title no),Title no)>1 and Pass/Fail = ''Pass','Pass','Fail')

[Chanty4u]

Try this 

=If(Count({<PassFail={'Pass'}>} DISTINCT TitleNo) > 0, 'Pass','Fail')