So I Have 5 access levels(RM -> Desk->Team->Group->BU). I have the employee table doesn’t quite split the levels of each employee, then I have another table (transactions) table that splits the levels but the case is the RM doesn’t only report to one desk.
You Could have Employee A an RM with Employee Code 00890 and he reports to Desk 101275, 103475, 108375.
I tried generating a manager ID so i could create a path;
Manager_ID = IF(RM_HIERACHY[GROUP_NAME] = “RM”,LOOKUPVALUE(BS_Updated[DESK_CODE],BS_Updated[RM_CODE],RM_HIERACHY[GROUP_VALUE]),Blank())
Error Message: A table of multiple values was supplied where a single value was expected
What I was trying to achieve is IF Group name is RM then give me corresponding Desk Code; when group name is Desk then give me corresponding Team_Code and so on. This is intended to build a path with.
I am quite new to DAX and on a timeline to deliver on this. Please I need urgent Help. I need a DAX Solution that works for this Scenario.