Access level hierarchy

Anonymous 

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! 🤠