Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Using RLS employee should see data for his organizational group as well as all his reportees data

Below is the Employee table showing Emp id , emp name email,Organization group, manager id , name and email. Each employee is assigned to more than one group (here 2 groups). Another is the sa...
Need Help
  • Chakravarthy's avatar
    Chakravarthy
    2 years ago

    Hi Anonymous 

    This should be model

    This should be Joins between tables:

    Table DAX Code:

    1. DISTINCT_EMP = DISTINCT(Employee[Employee Email])
    2. BRIDGE =
    VAR TABLE1 =
                SUMMARIZECOLUMNS(
                    Employee[Employee Email],
                    Employee[Manager Email]
                )

    VAR TABLE2 =
                SUMMARIZE(
                    Employee,
                    Employee[Employee Email],
                    "Manager Email", Employee[Employee Email]
                )

    RETURN
    UNION
    (
        TABLE1,
        TABLE2
    )
     
    3. BRIDGE1 = DISTINCT_EMP
    Please check this "Apply Security  Filter on Both Sides" when joining BRIDE and BRIDGE1

    In Manage Roles:

     

    Hope I answered your RLS. If so, please provide Kudos and encourage me.

Chakravarthy's avatar
Chakravarthy
Resolver II
2 years ago

Anonymous When I select "Leia Organa" It is showing "Kylo Ren" and "Darth Maul" Below is the screenshot 

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Chakravarthy .Kindly ignore previous reply\post since it worked !. Ihere was issue in relationship between Distinct_emp and Bridge table. After I correct that it worked !!Thanks. Accepted as solution. Thanks for your immediate help!.