hi team ,
I need a help,
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
| ARD | CLUSTER | BM | RM | RMMAIL | |
| ARD1 | CBE | BM001 | tom@gmail.com | RM002 | ramkumar@gmail.com |
| ARD2 | CBE | BM001 | tom@gmail.com | RM002 | ramkumar@gmail.com |
| ARD3 | CBE | BM001 | tom@gmail.com | RM002 | ramkumar@gmail.com |
| ARD4 | CBE | BM001 | tom@gmail.com | RM002 | ramkumar@gmail.com |
| ARD5 | CBE | BM001 | tom@gmail.com | RM002 | ramkumar@gmail.com |
| ARD6 | MAS | BM002 | ram@gmail.com | RM001 | gru@gmail.com |
| ARD7 | MAS | BM002 | ram@gmail.com | RM001 | gru@gmail.com |
| ARD8 | MAS | BM002 | ram@gmail.com | RM001 | gru@gmail.com |
| ARD9 | MAS | BM002 | ram@gmail.com | RM001 | gru@gmail.com |
| ARD10 | MAS | BM002 | ram@gmail.com | RM001 | gru@gmail.com |
| ARD11 | MDU | BM003 | karthick@gmail.com | RM002 | ramkumar@gmail.com |
| ARD12 | MDU | BM003 | karthick@gmail.com | RM002 | ramkumar@gmail.com |
| ARD13 | MDU | BM003 | karthick@gmail.com | RM002 | ramkumar@gmail.com |
| ARD14 | MDU | BM003 | karthick@gmail.com | RM002 | ramkumar@gmail.com |
| ARD15 | MDU | BM003 | karthick@gmail.com | RM002 | ramkumar@gmail.com |
| ARD16 | SA | BM004 | suriya@gmail.com | RM001 | gru@gmail.com |
| ARD17 | SA | BM004 | suriya@gmail.com | RM001 | gru@gmail.com |
| ARD18 | SA | BM004 | suriya@gmail.com | RM001 | gru@gmail.com |
Super user
| NAME | CLUSTER | |
| vinoth@gmail.com | vinoth | MAS |
| vinoth@gmail.com | vinoth | CBE |
| vinoth@gmail.com | vinoth | MDU |
| vinoth@gmail.com | vinoth | SA |
| vani@gmail.om | VANI | SA |
| vani@gmail.om | VANI | CBE |
| vani@gmail.om | VANI | MDU |
Sales
| ARD | SALES | DATE | INV NO |
| ARD1 | 5000 | 01-01-2024 | INV001 |
| ARD2 | 300 | 01-01-2024 | INV002 |
| ARD3 | 3500 | 01-01-2024 | INV003 |
| ARD4 | 5844 | 01-01-2024 | INV004 |
| ARD5 | 8000 | 01-01-2024 | INV005 |
| ARD6 | 5847 | 01-01-2024 | INV006 |
| ARD7 | 3543 | 01-01-2024 | INV007 |
| ARD8 | 46465 | 01-01-2024 | INV008 |
| ARD9 | 4543 | 01-01-2024 | INV009 |
| ARD10 | 64 | 01-01-2024 | INV010 |
| ARD11 | 6767 | 01-01-2024 | INV011 |
| ARD12 | 45645 | 01-01-2024 | INV012 |
| ARD13 | 768 | 01-01-2024 | INV013 |
| ARD14 | 4657 | 01-01-2024 | INV014 |
| ARD15 | 4674 | 01-01-2024 | INV015 |
| ARD16 | 467 | 01-01-2024 | INV016 |
| ARD17 | 69 | 01-01-2024 | INV017 |
| ARD18 | 467 | 01-01-2024 | INV018 |
| ARD1 | 6544 | 01-02-2024 | INV019 |
| ARD2 | 4354245 | 01-02-2024 | INV020 |
| ARD3 | 46 | 01-02-2024 | INV021 |
| ARD4 | 435354 | 01-02-2024 | INV022 |
| ARD5 | 346 | 01-02-2024 | INV023 |
| ARD6 | 56 | 01-02-2024 | INV024 |
| ARD7 | 356 | 01-02-2024 | INV025 |
| ARD8 | 356 | 01-02-2024 | INV026 |
| ARD9 | 356 | 01-02-2024 | INV027 |
| ARD10 | 785 | 01-02-2024 | INV028 |
| ARD11 | 857 | 01-02-2024 | INV029 |
| ARD12 | 63 | 01-02-2024 | INV030 |
| ARD13 | 54 | 01-02-2024 | INV031 |
| ARD14 | 52 | 01-02-2024 | INV032 |
| ARD15 | 54 | 01-02-2024 | INV033 |
| ARD16 | 457 | 01-02-2024 | INV034 |
| ARD17 | 4573 | 01-02-2024 | INV035 |
| ARD18 | 356 | 01-02-2024 | INV036 |
sales and cluster is related with many to one relation
cluster and superuser related with many to many relation
RLS DAX :
super user result not showing
Hi @rajasekar_o
You need to use the "Email" column of the "super user" table to write the Rls formula
The correct RLS formula should look like this:
'Super user'[EMAIL] = USERPRINCIPALNAME()
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @rajasekar_o
You need to use the "Email" column of the "super user" table to write the Rls formula
The correct RLS formula should look like this:
'Super user'[EMAIL] = USERPRINCIPALNAME()
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
