Need to Analyse Multi Level of Marketing network

[VijayP]

Dear @amitchandak 
I am trying to understand the Covid infection Cycle.

My question here is, There are Ten People in a locality and they are maintaining social distance.

However due to some reason they came into close contact. The chain is like below:

A contacted B

B concated C and D

C contacted E and F

I want to create a model where If i Create a Slicer of All people and Select A , i should able to see in the Table Visual all

A,B,C,D,E,F becasue A is the source of contact for all

and if I select B I should be able to see the below hierarchy like C,D,E,F etc.

Request your help!!

[Pragati11]

hi @VijayP ,

You can try looking into PATH creation using Parent-Child relationship in Power BI.

The following link gives a small tutorial on how to do it:

https://radacad.com/parsing-organizational-hierarchy-or-chart-of-accounts-in-power-bi-with-parent-ch...

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[VijayP]

Hi @Pragati11 

In the given exmaple the hierarchy is specific and parent ID is unique 

But in case of above example of mine, we never know whether on parent ID is multiple and it will not work using PATH Function!

I tried that! 

[VijayP]

the reason why it is not working because 

The boss, suboridinate relation is fixed in the RADCAD example where boss never becomes subordinate and vice a versa

but in my data any body can be the first level and also can be the low level, because A may contact B and B may contact A

so both A and B are here on Parent and also in Child hence PATH is not working

[v-jayw-msft]

Hi @VijayP ,

Can you share some sample data to us if you don't have any Confidential Information?

Best Regards,

Jay

[VijayP]

@v-jayw-msft 

This is the dummy data you can use to understand the problem statement.

Regards

Vijay Perepa

transaction_id         Emp ID Host        EMP Infect            date of contact

4909	20344	20762	5/19/2020
3335	20344	21061	5/19/2020
3454	20762	21061	5/19/2020
4178	20762	20344	5/19/2020
3340	Contract 1	21061	5/19/2020
3339	21061	20344	5/19/2020
3455	21061	20762	5/19/2020
3456	2500769	2310893	5/19/2020
4093	210613	Contract 1	5/19/2020
13954	214333	Contract 2	5/19/2020
210613	2500769	2319614	5/19/2020
13959	21061	2500769	5/19/2020
3457	2310893	2500769	5/19/2020

[VijayP]

@v-jayw-msft

Any luck Regards Vijay Perepa

[VijayP]

@v-jayw-msft Any luck Regards Vijay Perepa