Add column from many to 1 table

[Anonymous]

Greeting all , 

im trying to add a column from a table to another one ( the relation between them is many to 1 ) 

here is a sample : 

Table 1 :

Table 2 :

im trying to add the Category column to the table 2 , but i cant do it using the related Function , any help or tricks plaese .

Thanks all in advance 🙂 

[aj1973 · Accepted solution]

Hi @Anonymous 

Here you go

Category_ = CALCULATE(SELECTEDVALUE('Table 1'[Category]), USERELATIONSHIP('Table 1'[Class Num],'Table 2'[Class Num]))

[Anonymous]

Thanks , it works 😄 😄 

[aj1973]

Welcome