Calculated Column Based on Relationships in Three Tables

Thank you, lbendlin, for your response.

Hi kp_wood13,

We appreciate your inquiry through the Microsoft Fabric Community Forum.

Based on my understanding, to achieve the goal of pulling ServicesList[u_mc_rating] into DB List, kindly follow the workaround process of using a two-step DAX approach with LOOKUPVALUE to simulate relationships without causing circular dependencies:

1. In the DB List, retrieve the parent from ServicesToHosts:
   
   

   ParentFromHosts =

   LOOKUPVALUE(

       'ServicesToHosts'[parent],

       'ServicesToHosts'[child], 'DB List'[child]

   )

    

2. Use the parent to fetch  u_mc_rating from ServicesList:
   
   

   u_mc_rating =

   LOOKUPVALUE(

       'ServicesList'[u_mc_rating],

       'ServicesList'[name], 'DB List'[ParentFromHosts]

   )

If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members who are facing similar queries.

Thank you.