Forum Discussion

rajasekar_o's avatar
rajasekar_o
Helper V
2 years ago

RLS 3 Level

hi team ,
i need a help,for RLS
I set BM wise , RM wise and Super user wise
BM-wise and RM-wise RLS are working properly, but for the super user, the values are not showing
following tables are am using

Cluster table

ARDCLUSTERBMEMAILRMRMMAIL
ARD1CBEBM001[email protected]RM002[email protected]
ARD2CBEBM001[email protected]RM002[email protected]
ARD3CBEBM001[email protected]RM002[email protected]
ARD4CBEBM001[email protected]RM002[email protected]
ARD5CBEBM001[email protected]RM002[email protected]
ARD6MASBM002[email protected]RM001[email protected]
ARD7MASBM002[email protected]RM001[email protected]
ARD8MASBM002[email protected]RM001[email protected]
ARD9MASBM002[email protected]RM001[email protected]
ARD10MASBM002[email protected]RM001[email protected]
ARD11MDUBM003[email protected]RM002[email protected]
ARD12MDUBM003[email protected]RM002[email protected]
ARD13MDUBM003[email protected]RM002[email protected]
ARD14MDUBM003[email protected]RM002[email protected]
ARD15MDUBM003[email protected]RM002[email protected]
ARD16SABM004[email protected]RM001[email protected]
ARD17SABM004[email protected]RM001[email protected]
ARD18SABM004[email protected]RM001[email protected]
      

Super user

EMAILNAMECLUSTER
[email protected]vinothMAS
[email protected]vinothCBE
[email protected]vinothMDU
[email protected]vinothSA
[email protected]VANISA
[email protected]VANICBE
[email protected]VANIMDU

Sales

ARDSALESDATEINV NO
ARD1500001-01-2024INV001
ARD230001-01-2024INV002
ARD3350001-01-2024INV003
ARD4584401-01-2024INV004
ARD5800001-01-2024INV005
ARD6584701-01-2024INV006
ARD7354301-01-2024INV007
ARD84646501-01-2024INV008
ARD9454301-01-2024INV009
ARD106401-01-2024INV010
ARD11676701-01-2024INV011
ARD124564501-01-2024INV012
ARD1376801-01-2024INV013
ARD14465701-01-2024INV014
ARD15467401-01-2024INV015
ARD1646701-01-2024INV016
ARD176901-01-2024INV017
ARD1846701-01-2024INV018
ARD1654401-02-2024INV019
ARD2435424501-02-2024INV020
ARD34601-02-2024INV021
ARD443535401-02-2024INV022
ARD534601-02-2024INV023
ARD65601-02-2024INV024
ARD735601-02-2024INV025
ARD835601-02-2024INV026
ARD935601-02-2024INV027
ARD1078501-02-2024INV028
ARD1185701-02-2024INV029
ARD126301-02-2024INV030
ARD135401-02-2024INV031
ARD145201-02-2024INV032
ARD155401-02-2024INV033
ARD1645701-02-2024INV034
ARD17457301-02-2024INV035
ARD1835601-02-2024INV036


Relationships :

 

sales and cluster is related with many to one relation
cluster and superuser related with many to many relation 
RLS DAX :

BM:'CLUSTER'[EMAIL]=USERPRINCIPALNAME()
RM:'CLUSTER'[RMMAIL]=USERPRINCIPALNAME()
SUPER USER:'SUPER USER'[EMP ID]=USERPRINCIPALNAME()




super user result not showing

 

 

 

 

sales and cluster is related with many to one relation
cluster and superuser related with many to many relation 
RLS DAX :

BM:'CLUSTER'[EMAIL]=USERPRINCIPALNAME()
RM:'CLUSTER'[RMMAIL]=USERPRINCIPALNAME()
SUPER USER:'SUPER USER'[EMP ID]=USERPRINCIPALNAME()




General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi rajasekar_o ,
    Based on your description and the data provided, I observe that your dax expression references the [EMP ID] field, which may not work for the RLS relationship you are using. You can try using Super User[Email] to restrict it.

    Best regards,
    Albert He

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly