Bridge table with value split

[Anonymous]

Hi,

I'm struggling to create a bridge for my data set.

I have a data table with amount for each product reference :

Each product ref has an equivalent or is sometimes splitted through multiple ref in that way :

I would like to display the amount of each _key (that is each "new ref") according to the val column of my bridge table. For example the FR03 should add all amount of ref 003 + 50% of ref 004.

I was able to do so using this formula :

_AMT = CALCULATE(SUM(Data[AMT])*LOOKUPVALUE(Bridge[_VAL];Bridge[_CCT];SELECTEDVALUE(Bridge[REF])&SELECTEDVALUE(LAYOUT[_key]));Bridge)

But that require to display all concatenate :

How can I achieve this ?

Thanks for your help.

EDIT

The relationships are as follows :

Here is what I get when displaying data. We can see that left table is correct because all concatenate are displayed. Right one is not and FR03 is missing. So I guess the Dax is wrong.

[Anonymous]

@Anonymous,

I am able to get result when using your DAX.

What is the data in the LAYOUT table? And what are the relationships among the three tables? 

Regards,
Lydia