Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
71 | |
38 | |
29 | |
28 |
User | Count |
---|---|
99 | |
88 | |
62 | |
42 | |
39 |