question

SrividyaGunapati-5570 avatar image
0 Votes"
SrividyaGunapati-5570 asked MiguelEscobar-3907 edited

DAX formula for complex entity ownerships

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-supported
image.png (2.2 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Ehren avatar image
0 Votes"
Ehren answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.