Not Monitored
Tag not monitored by Microsoft.
37,797 questions
This question doesn't appear to be related to Power Query. DAX questions should be posted over on the Power BI Community site.
DAX formula for complex entity ownerships
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 98%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Srividya Gunapati
1
Reputation point
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.
1 answer
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 31%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEM%3C/text%3E%3C/svg%3E)
Ehren (MSFT) 1,781 Reputation points Microsoft Employee2021-07-21T22:37:00.293+00:00