Forum Discussion

alanc's avatar
alanc
Frequent Visitor
2 years ago

Displaying an exploded BOM with Parent Level selected from another Visual

Hi - I was trying to make this solution from post https://community.fabric.microsoft.com/t5/Desktop/display-all-child-hierarchy-based-on-parent/m-p/614562 work for a very similar situation and need a bit of help with the DAX.  I have a Visual A Parent table that when a row is selected, it needs to show the exploded BOM (of lower levels) in Table B Hierachy Matrix. Currently, the Parent Item populates Matrix B but does not allow me to drill down on the children (cause its filtered on parent).
The Hiearchy table is built using the solution found in this link and works as expected, enables a M:M approach  https://www.thebiccountant.com/2017/02/14/dynamically-flatten-parent-child-hierarchies-in-dax-and-powerbi/   Tried different approaches with no joy, there are some measures included with this flattened table to suppress blank nodes that may be causing some contention?  The biccountant link has a downloadable pbix if you need an example to work with. 
I have included the generated Hierachy table as reference in the diagram.  Currently I am going down only (3) levels) as shown in example.

 

1 Reply