The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hi, I have a two table information shared below
Person | Position | Site Name | Region | |
Daniel | Nurse | Chennai | Daniel@abc.com | APAC |
Mark | Medical Leader | Chennai | Mark@abc.com | APAC |
Dinesh | Physician | Chennai | Dinesh@abc.com | APAC |
Region | Country | Site | Created Date | Entered by | Case id |
APAC | India | Chennai | 4/1/2020 | Daniel | 1001 |
APAC | India | Chennai | 4/1/2020 | Mark | 1002 |
APAC | India | Hyderabad | 4/1/2020 | Dinesh | 1003 |
APAC | India | Hyderabad | 4/1/2020 | Daniel | 1004 |
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
User | Count |
---|---|
69 | |
64 | |
62 | |
55 | |
28 |
User | Count |
---|---|
112 | |
81 | |
65 | |
48 | |
38 |