Forum Discussion
Exploring Social Network graph Usage
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.
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 Thanks for your efforts.
Iam very thankful for your valuable time on this.
But as I MENTIONED IN MY PREVIOUS COMMENTS, that i am using this calculated colum values in
Social Network Graph, So that i Can show each employees Upperlevel and Lowerlevel hierarchy, and which is not going to be possible with the calculated table because i cant use this table values.
If i want to then again i have write the same LOOKUPVALUE function dax which leads me to the same current situation.
Please help me.