Forum Discussion

HemanthV's avatar
HemanthV
Icon for Helper II rankHelper II
4 years ago

user with ALL value should see everything

Hello Guys,

I have 3 tables:

SecurityTableTerritory:

UserNameTerritoryNameColumn Y/N
[email protected]American SamoaY
[email protected]ALLY
[email protected]GuamN
[email protected]ALLN
[email protected]Jarvis IslandN

AccountDim:

AccountIDAccountNameTerritoryName
ACC001WalmartAmerican Samoa
ACC002ConnsGuam
ACC003TargetHowland Island
ACC004SafewayJarvis Island
ACC005LuckyJohnston Atoll

SalesFact:

OrderNumberAccountIDOrderAmount
ORD1001ACC072560
ORD1002ACC073822
ORD1003ACC004261
ORD1004ACC090785
ORD1005ACC085958
ORD1006ACC019847

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 

Need Help

1 Reply

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    4 years ago

    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.