Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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,
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
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.