Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Exploring Social Network graph Usage

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 D...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    8 years ago

    Dear Anonymous, Abduvali,

     

    Ok, I'll share with step by step:

    • Create 4 new colum:

    Path = PATH(Employees[EmployeeName],Employees[ManagerName]) 

    Level 1 = PATHITEM(Employees[Path],1)

    Level 2 = PATHITEM(Employees[Path],2)

    Level 3 = PATHITEM(Employees[Path],3)

     

    • Create new "Emp Hierarchy" on Level 1. Then get Level 2 and 3 into this Hierarchy.
    • Download the Journey Chart. Put "Emp Hierarchy" in "Category Data", Salary in "Measure Data"
    • Make sure your Filter Emp with Level 3.

    That's it!

     

    If you need some help, don't be hesitate tag my name in your topic. I'll try if i can.

    Regards,

    ManNVSM.

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

So what about:

 

Table 2 = SUMMARIZECOLUMNS(Employees[Supervisor],Employees[Project Manager],Employees[Deliver Manager Name],FILTER(Employees,[Employee Name]="Meeta Jangde"))

How are you trying to actually use this? Is it in some kind of visual or in some other calculation? That is going to drive the solution.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Greg_Deckler I am very thankful for your help.

 

I tried what you have suggested. It works fine.

 

Then i tried to make it dynamic, like i choose values from a slicer.

 

So i tried the below dax

 

Table 2 = SUMMARIZECOLUMNS(Sheet3[Supervisor],Sheet3[Project Manager],Sheet3[Delivery Manager Name],FILTER(Sheet3,SELECTEDVALUE(Sheet3[ Employee Name]))
)

 

But i got all the null values. i didnt get any output.

 

Any suggestions.