I have the attached .pbix file that I'm trying to configure RLS for here. The TerritoryAssign table is maintained by our Sales Admin team, and I'm trying to find a solution where I don't have to reformat that table (if possible).
Here's the issue: I've seen many solutions that use RLS with two columns of data - Child and Parent. In the attached, I have three levels of a hierarchy - territory, district, and region. I cannot figure out the correct DAX formula to validate the RLS with these three levels.