Exploring Social Network graph Usage

[Anonymous]

Hello All,

I am using the Lookupvalue function for the first time.

I am trying to find out the values in a way that,

I have table as below.

Employee Name	Supervisor	Project Manager	Delivery Manager Name
Meeta Jangde	Venkat Reddy	Manoj Mone	Mandar Marulkar
Prashant Pandey	Venkat Reddy	Manoj Mone	Mandar Marulkar
Abhijeet Behare	Venkat Reddy	Vijay Venkatachalam	Manoj Mone
Abhijeet Behare	Venkat Reddy	Manoj Mone	Mandar Marulkar
Prithviraj Sawant	Venkat Reddy	Vijay Venkatachalam	Manoj Mone
Maulik Patil	Venkat Reddy	Vijay Venkatachalam	Manoj Mone
Mohan Vankudoth	Venkat Reddy	Manoj Mone	Mandar Marulkar
Supriya Dhekale	Venkat Reddy	Manoj Mone	Mandar Marulkar
SHRADDHA NALKAR	Venkat Reddy	Manoj Mone	Mandar Marulkar
Radhika Mantri	Venkat Reddy	Manoj Mone	Mandar Marulkar

Now I would like to get the values as,

For Emp Name--> Meeta Jangde

It should return as,

Meeta Jangde --> Venkat Reddy --> Manoj Mone --> Mandar Marulkar

How can i get it using lookupvalue funtion.

Or is there any way to get it using DAX.

Any help,

Thanks,

Mohan V

[Abduvali]

Hi @Anonymous,

Can you share original table view please to get a better understanding (screenshot or sample data)

Regards

Abduvali

[Anonymous]

Thanks for the quick reply @Abduvali

here is the sample screenshot

[Greg_Deckler]

Perhaps multiple LOOKUPVALUE's along with a CONCATENATE or CONCATENATEX?

[Anonymous]

thanks for the reply @Greg_Deckler.

Can you give a example.

I really thankful for your help.

[Greg_Deckler]

Not entirely sure how you want to return these, but something along the lines of:

MyLookup = CONCATENATE(
               CONCATENATE(
                            LOOKUPVALUE([Supervisor],[Employee Name],"Meeta Jangde"),
                            "--->"
                          ),
               LOOKUPVALUE([Project Manager],[Employee Name],"Meeta Jangde")
             )

[Anonymous]

Sorry for the wrong exaplanation @Greg_Deckler

You completely got wrong.

I jus need to get the hierarchy, not with those lines.

I have jus shown you how the hierarchy should return whenever i choose a Employee Name

[LaurentCouartou]

It it what you are looking for?

http://www.daxpatterns.com/parent-child-hierarchies/

[Anonymous]

@LaurentCouartou thanks for the reply.

I did try this. but when i use that column in  Social network graph( https://store.office.com/powerbiaddininstallpage.aspx?rs=en-US&assetid=WA104381236 ) Source name, it returns me only single value.

Any help.

[v-chuncz-msft]

@Anonymous,

Follow my above post and drag [Value] to Source: Name.

[Anonymous]

@v-chuncz-msft i tried it but no luck.

Its not working as i am expecting.

Its not reflecting the upper level employees also.

[Anonymous]

@v-chuncz-msft @LaurentCouartou @Abduvali @Greg_Deckler Any help please..

[Anonymous]

Dear @Anonymous,

I'm not clear your request about "But i got all the null values. i didnt get any output.".

Can you update your new pbix and tell more about your problem?

Regards,

ManNVSM.

[Anonymous]

Thanks for the reply @Anonymous

I mean to say that i didnt get any output with that dax.

When i used the first dax it returns me the manager name value.

But when i included the selectedvalue function, it returned the null value.

Here, actually my real concern is 

i need a calculated column which should return the multiple values when i  choose a value from a slicer.

With that dax i can create table which is of no use for me as of now.

For each value that i choose, if should return the direct and indirect connected values.

[Anonymous]

Dear @Anonymous,

I'm create a new Table 2 = SUMMARIZECOLUMNS(Employees[ManagerID] , Employees[ManagerName], FILTER(Employees, SELECTEDVALUE(Employees[EmployeeName])))

It's base on your above DAX. And you want to show Manager when selected an employee like this?

If my simulation about your problem is correct, I'm sorry I can't help. Because only Measure can refresh data.

Can you tell me more about your expect? Maybe we can find another way to solve it.

Regards,

ManNVSM.

[Anonymous]

@Anonymous 

Thanks for asking. I have a debt to pay you. 

This is what i am trying to implement.

By using Social Network Graph, i would like to create organization level span of control for each and every employees.

Why am i going with only this visual is, because we can show lot of info and at the same time it is much ettractive than the other directed and network graph.

So here whenever i choose i person name i should be able to show his complete hierarchy levels.

that is nothing but his direct and indirect connections(till ceo level )

In this https://store.office.com/powerbiaddininstallpage.aspx?rs=en-US&assetid=WA104381236 

you can find the sample for that.

Please help me.

[Anonymous]

Dear @Anonymous,

So, your expect is "So here whenever i choose i person name i should be able to show his complete hierarchy levels."

For ex: when click on Emp Name "Jorder", you want this chart show "Paul - Envy - Jorder"? Or something amazing more?

Regards,

ManNVSM.

[Anonymous]

@Anonymous Absolutely.

Thats exactly what i need to get.

But it should be connected.

Like in this table if you see,

No  Name   Manager ID
1     A
2     B           1
3     C           2
4     D           3
5     E            3
6     F            4
7     G           6
8     H          6

If i choose A...He is at top level because he is not having any manager ID so for him we need to show

the lower level hierarchy that how everyone is connected to each other.

If i choose E... then we need to show his upper level hierarchy ie E connected to C, C connected to B, and B connected to 1

and also his lower hierarchy if present. For E theres no lower hierarchy.

But for F we have the lower and upper hierarchy.

this is what i am trying to implement.

[Anonymous]

Dear @Anonymous,

It's seem i reach your heart (just kidding).

Ok, i have an idea and i need to make some test. I'll be right back.

Regards,

ManNVSM.

[Anonymous]

@Anonymous I ll be waiting for your reply with thousands of eyes. 

[Anonymous]

Dear @Anonymous,

After trying many way, I just realize that Social Chart doesn't support the way you want

I'm so sorry because it out of my range, maybe you can think about submit new idea for that Social chart.

The only one "Journey Chart by MAQ" can do it with Hierarchy.  You can see the picture below, it can show full (I admit I can not remove the Root node). If you think again and sacrify your beautifull Social chart, then we can discuss this ugly solution.

Hope you can pass this sadness soon!

Sincerely,

ManNVSM.