Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

 

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.

1 Reply

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support

    hi, Anonymous 

    If this formula meets your requirement?

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

     

    Best Regards,

    Lin