Check column for any instance of a value, provide a way to show "Fail"

[wolverine1010]

Hello, I'm looking for a way to set up a simple visual that displays either pass/fail, based on if a value is found in a column of a table.

So for example, there's two columns. If the number "1" is found in any cell within column 2, a subsequent visual should reflect this (maybe a card saying fail?). If it's not found, the text/card should say "pass" or something like that. Thanks for help, I'm pretty new and doing my best to learn as quickly as I can for a project I need to take on. 

[wolverine1010]

Process	Value
Alpha	1
Beta	0
Theta	1
Omega	2

So let's say since 2 has been found within this table, we need to display a fail.

[onurbmiguel_ · Accepted solution]

Hi 

Is this the output wanted ?  

i creat this calculated column : 

Result = 
if('Table (2)'[Value] > 0 , "Fail" , "Pass" ) 

You need to have the column "Value" set as number 

Best regards

Bruno Costa | Solution Supplier

Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 👍

Take a look at the blog: PBI Portugal 

[wolverine1010]

Thank you, that's exactly what I needed!

[onurbmiguel_]

Hello wolverine1010

Can you share some dummy values , 

Thanks 

Bruno