Great Video on Hierarchies! I have one quick doubt, When we have multiple levels, I hope we will end up in multiple columns, Instead we can use PathContains and return the value in Manage Roles. Please let me know your thoughts!
Just one more thing, the microsoft documentation mentions: "rely on well-designed relationships to ensure RLS filters propagate to other model tables. So, avoid using the *LOOKUPVALUE* DAX function when model relationships could achieve the same result." this part contradicts this video.