RLS modeling for dynamically filtering

[Anonymous]

Have an RLS dynamic filtering question

Have the user email along with the Divisions that users can see the data in following format. 

Location	email	Division 1	Division 2	Division 3	Division 4
EAST	Group1@abc.com	ABC Div	XYZ Div	123 Div
EAST	Group2@abc.com	ABC Div	XYZ Div	123 Div	NEW Div
SOUTH	Group3@abc.com	777 Div	555 Div

Fact has GI's for divisions . Group1@abc.com should see only the qty of 50 for 3rd Oct. How can i filter in RLS for all various divisions based on email. 

GI No	Date	Qty	Division
1000	1-Oct-21	25	XYZ Div
1001	3-Oct-21	30	ABC Div
1002	3-Oct-21	20	ABC Div
1003	15-Oct-21	70	555 Div
1004	15-Oct-21	50	123 Div
1005	20-Oct-21	100	NEW Div

on the Access Grp, i used email = USERPRINCIPALNAME(). Struck on dynamic filtering of location and divisions. 

Pbix is https://drive.google.com/file/d/1LKEIZmqAghp-El47AB_r0uWo0nWEbuCp/view?usp=sharing

[amitchandak]

@Anonymous , You have to unpivot the first table to bring division in rows to use RLS on division

https://radacad.com/pivot-and-unpivot-with-power-bi

[Anonymous]

Thanks @amitchandak . I did unpivot them. But my question was on how filtering can be done dynamically