DAX formula for complex entity ownerships

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.

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

    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