How to get Related column on double relation

[alperatay]

Hi, i created database in SQL Server and looks like relationships is:

Product table CostPriceId and ListPriceId connected to ProductPrice Id column and ProductPrice.CurrencyId connected to Currency.Id

I want to create column as ListPrice and CostPrice on relationship. 

Like this: 

CostPrice = RELATED('Currency'[Symbol]) & " " & RELATED(ProductPrice[Amount])

ListPrice = RELATED('Currency'[Symbol]) & " " & RELATED(ProductPrice[Amount])

It's work but correctly work only on CostPriceId. How can change relation on CostPriceId and ListPriceId by column. I can't found like that problem. RELATED working on just CodePriceId value.

Thanks

[amitchandak · Accepted solution]

@alperatay , You can get like this using ListPriceId 

maxx(filter( ProductPrice, product[ListPriceId] =ProductPrice[ID]),ProductPrice[Amount])

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8