Solved: Access level hierarchy

yuktadiya · ‎01-31-2024

hi All

here the condition is

1 EVP has to see all the below levels (i.e he has to see (Org_Unit_EVP_ID,Org_Unit_VP_ID,Org_Unit_Level_1_ID,Org_Unit_Level_2_ID)

2 VP has to see his Org_Unit_VP_ID and as well as below levels ( i.e Org_Unit_VP_ID,Org_Unit_Level_1_ID,Org_Unit_Level_2_ID)

3 Level 1 has to see his Org_Unit_Level_1_ID as well as below levels.( Org_Unit_Level_1_ID,Org_Unit_Level_2_ID)

4 Level 2 has to see his Org_Unit_Level_2_ID and he should not see rest of above levels

5 Org_key is common column for all the tables

Email	Org_Unit_EVP_ID	Org_Unit_VP_ID	Org_Unit_Level_1_ID	Org_Unit_Level_2_ID	Access Level	Org_Key
dilip@gmail.com	59715700				EVP	5971640754064374
bhagya@gmail.com	59716036	59716036			VP	5971637459716482
sowmya@gmail.com	59716036	59716036	59716080		VP-1	5971637459716394
shyam@gmail.com	59716036	59716036	59716264	59716085	VP-2	5971608059716085
goel@gmail.com	59716036	59716036	59716352	59716230	VP-2	5971626459716279

can anyone helpout with this please share powerbi file

Regards

Dilip

Daniel29195 · ‎02-01-2024

@yuktadiya

https://www.youtube.com/watch?v=V7XWLqdvzYM

the last letter was not taken into the link

try now .

View solution in original post

Daniel29195 · ‎01-31-2024

@yuktadiya

you need to restruture your table if possible as follow :

child parent

B A

C A

D B

E B

F D

A

this way, you can use builint hierarchy dax functions that in turn will help achieve what you want .

hope this helps

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution !✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠