Network Navigator Multi-Level Hierarchy Issue

[amitg]

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

[MFelix]

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/