Row level security with multiple profil

[sidyahmet]

Personnel table

id_user	user	email	status	store
1	jonathan32	[email protected]	Directeur des ventes	Toulouse
2	maxgrant	[email protected]	Chef de store	Cannes
3	lberry	[email protected]	Vendeur	Metz
4	arnoldsamantha	[email protected]	Vendeur	Le Havre
5	ijohnson	[email protected]	Vendeur	Nantes
6	leahsmith	[email protected]	Chef de store	Saint-Paul
7	derrickchung	[email protected]	Vendeur	Créteil
8	robertholloway	[email protected]	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