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 isUnobta...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, Anonymous 

If this formula meets your requirement?

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

 

Best Regards,

Lin