The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Personnel table
id_user | user | 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?
Solved! Go to Solution.
I finaly found the solution
thanks