Is it possible to get a one-to-one relationship with a duplicated table?

[Anonymous]

Hi,

So I am trying establish a one-to-one relationship with a table and its duplicate due to dependency issues with calculated columns. Is there a way to establish a one-to-one relationship with a table if it has repeated values?

Thanks!

[Anonymous]

Hi @Anonymous 

If there are reapeted values, how can it be 1:1?

Cheers!
A

[Anonymous · Accepted solution]

I believe I was going about the problem incorrectly, I was trying to have the data match up row-for-row. I created a duplicate to create another calculated column, due to the dependencies created on the entire table when creating a calculated column. I ended up splitting the duplicated table into two different ones by filtering certain data in and out of the column I wanted to split the table on and used that instead. Thank you for the reply!

[v-chuncz-msft]

@Anonymous ,

You may take a look at the following post.

https://community.powerbi.com/t5/Desktop/Can-t-link-2-columns-one-of-which-is-calculated/m-p/351000#M157793