construct a complex "or" statement using values from another table

[tino123]

I have a calculated column like this:

Unobtainable = 

VAR isUnobtainable = myTable[attribute1] = "FAULTY" || myTable[attribute2] = "FAULTY" || myTable[attribute3] = "FAULTY"

RETURN isUnobtainable

Instead of being hardwired like this I want to reference an deviceAttributes table which has a single column attributes with the values attribute1, attribute2, attribute3.

[v-lili6-msft]

hi, @tino123 

If this formula meets your requirement?

Column = "FAULTY" IN CALCULATETABLE(VALUES(Table1[Value]),ALLEXCEPT(Table1,Table1[Type]))

Best Regards,

Lin