I have a scenario where there are multiple Child Keys for a single Parent key. Attached has a sample mapping I'm referring to here. PATH formula is not working since B and C child keys have just one Parent Key A. Example: (i) X and Y companies invest in Z, (ii) Z invests in A, and (iii) A invests in B and C.

Could you suggest a query or alternate/combination of DAX formulas I can use in such scenerios.