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.
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.
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.