RLS with Hirerachy

[Truelearner]

I have data in below format and i am importing them into SSAS to create a tabular cube and i have to create rls on the below data 

logic is whenever an emp with level as high level logs into power bi report , he should be able to see his data and all lowlevel employes data in his department , whenever a lowlevel emp logs in he should be seeing only his data within his department .

also i want to caluclate their rank depending on their sales and when high level employee logs in he should be able to see his department rank when compared to other departments but when lowlevel employee logs in he shoudl see only his rank in department and overall rank in firm. 

High level	Low level	Dept	ID
highlevel		1	1
	lowlevel	1	2
	lowlevel	1	3
	lowlevel	1	4
	lowlevel	2	5
	lowlevel	2	6
highlevel		2	7
highlevel		2	8
highlevel		3	9
	lowlevel	3	10

Dept	emp
1	1
1	2
1	3
1	4
2	5
2	6
2	7
2	8
3	9
3	10

ID	Sales
1	10
2	20
3	30
4	40
5	50
6	60
7	70
8	80
9	90
10	10

level	ID	Sales	Rank indivual	Rank in Department	Dept Rank in Firm
highlevel	1	10	1	4	3
lowlevel	2	20	2	3
lowlevel	3	30	3	2
lowlevel	4	40	4	1
lowlevel	5	50	5	4
lowlevel	6	60	6	3
highlevel	7	70	7	2	1
highlevel	8	80	8	1	1
highlevel	9	90	9	1	2
lowlevel	10	10	10	2

@mgwena @cham @amitchandak @Greg_Deckler @Mariusz @yij @yij @ v-yingj@v-diye-msft@v-xicai @v-eachen-msft @v-lionel-msft @v-juanli-msft @v-jayw-msft @v-kelly-msft  @v-zhenbw-msft

[lbendlin]

Do you have a proper hierarchy that you can traverse with PATH, PATHITEM etc?  If yes then you can base your RLS on that.  If not then just create roles per level and assign your users as needed. RLS Roles are optimistic. The role with the bigger scope overrules a conflicting role with smaller scope.

[Truelearner]

i dont have any of such hirerachy , over weekend i tried many things but nothing worked out 

i tried creating two individual tables one for high level and one for low level with columns dept , id ,lowlevel and dept , id ,highlevel and made a join between them on department to create the hirerachy but no use .

I really need help of community support team here as i have to complete atleast RLS by end of monday