Forum Discussion
Ragged Hierarchy?
Hello, Reaching out for help as I am desperate after researching for a few weeks. I have one table in a hierarchy structure (entity_tbl) - the max level/depth is 2. This links to the Roles table ...
Hi Anonymous , Thank you for reaching out to the Microsoft Fabric Community Forum.
I reproduced the scenario on my end using sample data and it worked successfully. To help you better understand the implementation, I’ve attached the .pbix file for your reference. Please take a look at it and let me know your observations.
Thank you for being part of the Microsoft Fabric Community!
Since I couldn't find a way to attach my PBIX, below are examples of the two tables. They are linked via relationship - Element-Element. I just don't completely understand how to use the entitypath and depth, etc. to implement a solution.
Entity Table
Roles Table