Row level security with multiple profil

[sidyahmet]

Personnel table

id_user	user	email	status	store
1	jonathan32	jonathan32@bi-ready.com	Directeur des ventes	Toulouse
2	maxgrant	maxgrant@bi-ready.com	Chef de store	Cannes
3	lberry	lberry@bi-ready.com	Vendeur	Metz
4	arnoldsamantha	arnoldsamantha@bi-ready.com	Vendeur	Le Havre
5	ijohnson	ijohnson@bi-ready.com	Vendeur	Nantes
6	leahsmith	leahsmith@bi-ready.com	Chef de store	Saint-Paul
7	derrickchung	derrickchung@bi-ready.com	Vendeur	Créteil
8	robertholloway	robertholloway@bi-ready.com	Vendeur	Roubaix

status colonne have three profile "Directeur des ventes","Chef de store"and "Vendeur".

I need to create a dynamic role in power bi desktop to filter data by email and status using Userprincipalname().
- User with status Directeur des ventes, can show all data any restriction with this user
- User witht status Chef de store can only see data associated with their store
- User with status Vendeur can only see row with only data.
I beguin doing this role  formula in dax role Email=Userprincipalname() 
How can I improve the formula to account for the cases mentioned above?

[sidyahmet · Accepted solution]

I finaly found the solution
thanks