Using OR in a RELATED calculated column - return value based on two related tables

[sunb1]

Hi - PLEASE HELP!! 🙂

i have two lookup tables connected to a data table. Both can get me the column i want in the data table (ie, INDUSTRY), but through different relationships. Can I use the OR function in a RELATED calculated column so that it will retrieve the correct INDUSTRY based on EITHER lookup table 1 or lookup table 2?

Thank you!!!

[Anonymous]

@sunb1 try using variables to get this

Industry col final =

var ind1 = related(table 1 industry)

var ind2 = related(table 2 industry)

return if(condition, ind1,ind2)

if it is driven by filters then it will have to be a measure.

[sunb1 · Accepted solution]

So that's the approach i took, but i had to to do two calculated columns using RELATED and then a final column with an IF statement, saying if the answer is not satisfied from the first column, then use the second column. 

[Anonymous]

@sunb1 hey just curious, isn't my ans the accepted solution to your problem?

[Anonymous]

I dont think you can use OR function in RELATED function.