How to call column value from a table with one to many relation

[Nikit18]

I'm facing a problem while pulling column value from related table. 

Table A -Table B are in Many to one relationship.

Table A

Route ID	Col Value
Route1	ABC
Route1	ABC
Route1	ABC

Table B

Route ID	Column value
Route 1	ABC
Route 2
Route 3

Can someone suggest how to call unique value in case on Many to One related table. 

[v-yalanwu-msft · Accepted solution]

Hi, @Nikit18 ;

Not sure if you understand what you mean correctly, you can create a column by dax.

Column = CALCULATE(MAX('TableA'[Col 1]),FILTER('TableA',[Key_ID]=EARLIER(TableB[Key ID])))

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Nikit18]

Thanks

[Nikit18]

@amitchandak : Do you have any suggestions on this ?

[croberts21]

Another way to put this is "remove duplicate values for a column." I have not seen a way to do this in PBI but you may try doing a search with those new keywords. 

[PhilipTreacy]

Hi @Nikit18 

The problem is not clear to me.  Can you try explaining it again with more detail and providing an example of the result you want.

Regards

Phil

[Nikit18]

Hi Phil, 

Let me explain you in this way. 

Table A is related to Table B with Many to One , ie, there are multiple rows in Table A vs unique row for Table B. Now I want to pull a column from Table A to Table B and data type is String. 

Table A

Key_ID	Col 1
ABC_123	Ex1
ABC_123	Ex1
ABC_123	Ex1
ABC_123	Ex1
ABC_123	Ex1
ABC_124	EX2

Table B: 

Key ID
ABC_123	Ex1
ABC_124	Ex2
ABC_125
ABC_126