Link multiple value column

[Gowtham30]

Hi ,

I've a issue here. I am trying to create a relationship between two tables as shown in the picture. I am looking to have one table that filters Minimum requirement, actual skills , Description, current positions based on the name that i have in slicer. For some reasons I am getting the duplicate values in my table and i couldn't able to figure it out where it is coming from. 

Any help would be greatly appreciated. 

Thanks,

Relationships

[amitchandak]

@Gowtham30 , You can create a concatenated column and use that as key

key = [col1] &"-" & [col2] &"-"& [col3]

[Gowtham30]

Hi Amit,

Thanks for your reply, I tried merging two columns in both tables and used as a key. When i was trying to plot the tables the output looked liked this. The required value columns comes empty. I am still missing some connections i guess. Thanks,

[v-kelly-msft]

Hi @Gowtham30 ，

In your oringinal post,as the relationship between the 2 tables are many to many and you dont have a unique key,that's why you have duplicate values.

And in the last reply,as the direction in the relationship is single,so it may filter out some value,pls try to change the direction from single to both,see below:

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Gowtham30]

Hi, @v-kelly-msft @amitchandak 

I did change the filtering to both ways but my model still not pulling any values in the required value column.

Please advise.

Thanks,

[v-kelly-msft · Accepted solution]

Hi @Gowtham30 ,

Click the visual>go to field>right click the column(not showing all the data)>"show item with no data":

Check whether this way will present all the data.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Gowtham30]

Somebody help, Please.

Thanks !!

[Gowtham30]

Hi Amit,

Thanks for your reply, I tried merging two columns in both tables and used as a key. When i was trying to plot the tables the output looked liked this. The required value columns comes empty. I am still missing some connections i guess. Thanks,