DAX help Compare table entries to find if any value is true

[bburgess]

Noob DAX question; (see picture for clarity)

I have a list of employees in the right table 'People', and I need to create a new column that returns a true or false value depending on if any of their 'Risk2' values in the other table 'Improvement' is true.

In this example, Alen Nichols would return a 'True' value, Alondra Cortes would return 'False'

[v-chuncz-msft · Accepted solution]

@bburgess 

You may learn to use CONTAINS.

https://community.powerbi.com/t5/Desktop/How-to-calculate-Supplier-wise-status-count/m-p/508726#M237...

[bburgess]

Thanks @v-chuncz-msft v-chuncz-msft  !