user with ALL value should see everything

[HemanthV]

Hello Guys,

I have 3 tables:

SecurityTableTerritory:

UserName	TerritoryName	Column Y/N
Dinesh@abc.com	American Samoa	Y
satish@abc.com	ALL	Y
Srinivasulu@abc.com	Guam	N
Venkata@abc.com	ALL	N
prashanth@abc.com	Jarvis Island	N

AccountDim:

AccountID	AccountName	TerritoryName
ACC001	Walmart	American Samoa
ACC002	Conns	Guam
ACC003	Target	Howland Island
ACC004	Safeway	Jarvis Island
ACC005	Lucky	Johnston Atoll

SalesFact:

OrderNumber	AccountID	OrderAmount
ORD1001	ACC072	560
ORD1002	ACC073	822
ORD1003	ACC004	261
ORD1004	ACC090	785
ORD1005	ACC085	958
ORD1006	ACC019	847

Now, In the securitytable there are users with Territory names assigned and for some users the is a value "ALL". When user with "ALL" logs in he needs to see all territories. when territory assigned user login then he should see only his territory data. 

There is Y/N column in security table. people with Y value should see order amount and people with N value should see null value.

when admin login ( 'ALL' territory people) he should see order amount irrespective of Y/N for all people and territories but i am getting Null because some people have N value in the column

admin needs to see everything. Attaching pbix for referrence

https://drive.google.com/file/d/1pFNLI0gvXj_x2dUrNNH_BdJzhIKc5Pkj/view?usp=sharing

Please help me with this!

Thanks in advance!

@amitchandak @parry2k 

[parry2k]

@HemanthV I recently did a video on RLS which somewhat address a similar scenario, check these videos here. Here is the link https://youtu.be/YkSIl65Q6i8

I would recommend subscribing my YT channel where I usually address real time Power BI problems.

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.