Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Anonymous
Not applicable

Need Help - Row Level security

Hi, I have a two table information shared below 

PersonPositionSite NameEmailRegion
DanielNurseChennaiDaniel@abc.comAPAC
MarkMedical LeaderChennaiMark@abc.comAPAC
DineshPhysicianChennaiDinesh@abc.comAPAC

 

RegionCountrySiteCreated DateEntered byCase id
APACIndiaChennai4/1/2020Daniel1001
APACIndiaChennai4/1/2020Mark1002
APACIndiaHyderabad4/1/2020Dinesh1003
APACIndiaHyderabad4/1/2020Daniel1004

I want to apply low level security as the condition of Medical Leader should see all cases and other persons should see cases based on login and location he shared with others , I have given desired result below

 

If Daniel is logged in - He can see 3 records(Case ID: 1001,1002,1004)
If Mark is logged in - He can see all 4 records(Case ID: 1001,1002,1003,1004)
If Dinesh is logged in - He can see 3 records(Case ID: 1001,1002,1003)
Kindly suggest

 

 
 
 
2 REPLIES 2
Greg_Deckler
Community Champion
Community Champion

Perhaps https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Hierarchical-Row-Level-Security/td-p...


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
amitchandak
Super User
Super User

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.