How to use data from a column in a measure?

[M-M-P]

Hi
Maybe there is a very simple solution to this, but I can't find anything that helps.

As you can see below, I have a column with "Yes" and "No".

I would like a measure to examine, row by row, whether it says Yes or No.

Something like this:

Measure = IF(Table[Yes No] = "Yes", "Good", "Bad")

Thanks

[v-diye-msft · Accepted solution]

Hi @M-M-P 

You can also use a measure below:

Measure = IF(Max(Table[Yes No]) = "Yes", "Good", "Bad")

Please kindly mark the answer as a solution if it helps. thanks a lot!

[amitchandak]

I think you should able to create it as column not measure

Column =IF(Table[Yes No] = "Yes", "Good", "Bad")

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
Thanks.

[M-M-P]

Hi @amitchandak 
Thanks for your input.
It might be the best solution 🙂

Thanks.