DAX Function to Create a Column Based on condition / filter in another column

[hassanh_2]

Hello,

Im trying to create a new column that returns a value from another table based on condition / filter.

As you see I have the following 2 tables. I want to create a new column in Table 2, in that column I need to return the "Sales Person" of the first Log_ID.

(Note: in my relationship model there is an Inactive relationship by "Acct Nr.") 

[hassanh_2]

Is there a way though to create it as a Column so I can use it as a Parameter dimension in other visuals?

[tamerj1]

@hassanh_2 

What is the direction of the relationship between the two tables? Can you provide a screenshot?

[hassanh_2]

I created the same function as a measure and it worked. Thank you!

[tamerj1 · Accepted solution]

Hi @hassanh_2 
Please try

NewColumn =
MAXX (
    TOPN (
        1,
        CALCULATETABLE ( Table2, USERELATIONSHIP ( Table1[Acct Nr], Table2[Acct Nr] ) ),
        Table2[Log_ID], ASC
    ),
    Table2[Sales Person]
)

[hassanh_2]

Hi, Thanks!

It seems you switched the Table Numbers but I tried both ways and the new column didnt return any value!