Forum Discussion
Network Navigator Multi-Level Hierarchy Issue
Hi all,
I have "units" which depend on each other, and I want to visualize the relationship between them with Network Navigator (best option I found). relationships look like this:
(-> = depends on)
A -> B, C
B -> D
C -> E, F
S -> U,V
AFAIK, the right way to model this type of relationship is by source + target fields, something like this:
| source | target |
| A | B |
| A | C |
| B | D |
| C | E |
| C | F |
| S | U |
| S | V |
The problem raises when I want to filter only A and see all its relevant dependencies, but only his. If I filter "source"=A, I get only A's direct dependencies (B, C) and not other levels (B->D, C->E, F).
If I'm not filtering at all, I get also S and its dependencies, which are irrelevant if my goal is to investigate A.
Of course it's a big issue when the scale is much larger, when I have tens of thousands of units.
Thought about adding levels of hierarchy ("level1", "level2") to "source" and "target" fields, but then it doesn't fit the visual's structure/needed parameters.
Anyone faced this issue before? Any smart idea how to solve it?
Thanks in advance ๐
Amit
1 Reply
- MFelixSuper User
Hi amitg ,
You need to create a parent-child hierarchy calculation.
Check the links below:
https://www.daxpatterns.com/parent-child-hierarchies/
https://www.sqlbi.com/blog/alberto/2011/07/19/parent-child-hierarchies-in-tabular-with-denali/