Row Level security for multiple tables not working as expected

I have a requirement to apply RLS in my Agile dashboard which is created on Dataverse tables. I have 3 tables- Stories, Defects & Enhancements. I also have Business Units for 4 teams- MS team, Sales team, Manager team, Client team. The Hierarchy is- MS team & Sales team are independent of each other and fall under Manager team. Under MS team, we have Client team. All of these teams have their own Business units and BUs also follow the same Hierarchy. I want to implement RLS in such a way that Manager team can see everything unfiltered. Sales team can see only their BUs data. MS team can see their BUs data and Client teams BUs data. Client team only sees their BUs data. 

I created the following roles- 

For Client I applied same filters on the following tables- 

For Sales, I applied same filters on the following tables- 

For Managers I did not apply any filter.

For MS I applied same filters on the following tables- 

As these are the names of my Business units.

I am trying to get correct results but on applying these conditions, My dashboard shows empty charts.

Kindly help