Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi All,
I need one help in design Dax. I'm trying to set RLS such that from single department or team, one team lead data can be visible or accesible to another team lead.
for e.g. If team name is - Finance and it contain 4 lead's they can see each other team member performance view..
Can anyone help in this please..
Solved! Go to Solution.
@PowerBIBeginer , refer if this can help
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
This is really good link, Amit.. Thanks for quick reply..!!
@PowerBIBeginer , refer if this can help
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 41 | |
| 38 | |
| 36 | |
| 30 | |
| 28 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |