Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
84 | |
75 | |
68 | |
41 | |
35 |
User | Count |
---|---|
107 | |
56 | |
52 | |
48 | |
40 |