Evaluate A Column for Yes, If a single Yes is present, Write the YES in a card Not Count

[PowerHelp45]

So hoping someone can provide some assistance here.  I have a column, that has either Yes or null as the value and in most cases its null.  What I would like to do is evaulate that column, if there is a "Yes" anywhere in the column whether its 1,50 or 10,000, I want it to write YES as the value in a card.  If the value is null for all entries then I want it to write NO.   I'm trying to identify on a dashboard whether or not something is present/happened at all.  The count is not relevant, the only thing relevant is if something happened or not. 

Thanks, apprciate the help

[v-luwang-msft]

Hi @PowerHelp45 ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft]

Hi @PowerHelp45 ,

Could you pls share sample data and expected output.

there is a "Yes" anywhere in the column whether its 1,50 or 10,000, I want it to write YES as the value in a card.  

 like the below?

column:

150

10000

null

output:

Yes

Yes 

null

Best Regards

Lucien

[tamerj1]

Hi @PowerHelp45 

you can try something like 

IF ( ISEMPTY ( VALUES ( TableName[ColumnName] ) ), "NO", "YES" )

otherwise we can add FILTER. First let me know if this works with you or not. 

[PowerHelp45]

Thanks for the reply!  So it seems to produce a YES under all conditions.  I attempted to replace null on the backend souce in the event the null was messing with the ISEMPTY.  No luck.

[tamerj1]

@PowerHelp45 

Please try

Has "Yes"? =
IF (
    ISEMPTY (
        FILTER ( VALUES ( TableName[ColumnName] ), TableName[ColumnName] = "Yes" )
    ),
    "NO",
    "YES"
)