DAX formula for complex entity ownerships

Srividya Gunapati 1 Reputation point
2021-06-18T10:44:03.49+00:00

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.

107008-image.png

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

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,918 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Ehren (MSFT) 1,781 Reputation points Microsoft Employee
    2021-07-21T22:37:00.293+00:00

    This question doesn't appear to be related to Power Query. DAX questions should be posted over on the Power BI Community site.

    0 comments No comments