Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Solved! Go to Solution.
Dear @Anonymous, @Abduvali,
Ok, I'll share with step by step:
Path = PATH(Employees[EmployeeName],Employees[ManagerName])
Level 1 = PATHITEM(Employees[Path],1)
Level 2 = PATHITEM(Employees[Path],2)
Level 3 = PATHITEM(Employees[Path],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.
Hi @Anonymous,
Can you share original table view please to get a better understanding (screenshot or sample data)
Regards
Abduvali
Perhaps multiple LOOKUPVALUE's along with a CONCATENATE or CONCATENATEX?
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")
)
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 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.
@Anonymous,
Follow my above post and drag [Value] to Source: Name.
@v-chuncz-msft i tried it but no luck.
Its not working as i am expecting.
Its not reflecting the upper level employees also.
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.
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.
@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.
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 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.
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 I ll be waiting for your reply with thousands of eyes.
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
86 | |
83 | |
65 | |
49 |
User | Count |
---|---|
127 | |
108 | |
89 | |
70 | |
66 |