Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Need Help on Row Leve Security

Need Help . Below is the DAX Expression I am using to see Data for Manager and his Team. I need to only see Team data and not the manager himself. PATHCONTAINS(Table[C_org Heirarchy], MaxX( Fi...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Anonymous ,

     

    You can add a filter condition.

    PATHCONTAINS (
    Table[C_org Heirarchy],
    MAXX (
        EXCEPT (
            FILTER ( Table, [Person_EmailAddress] = USERPRINCIPALNAME () ),
            FILTER ( Table, [Person_EmailAddress] = "Manager email address" )
        ),
        Table[Person_EmpID]
    )
)
v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi Anonymous ,

 

You can add a filter condition.

PATHCONTAINS (
    Table[C_org Heirarchy],
    MAXX (
        EXCEPT (
            FILTER ( Table, [Person_EmailAddress] = USERPRINCIPALNAME () ),
            FILTER ( Table, [Person_EmailAddress] = "Manager email address" )
        ),
        Table[Person_EmpID]
    )
)
Anonymous's avatar
Anonymous
Not applicable
6 years ago

 you for that.However ,  get an error msg : "Too many Arguments were passed in MAXX"

 

Below is how my expression looks

 

PATHCONTAINS(Table[C_org Heirarchy],
MaxX(
EXCEPT(
Filter(
Table,
[Person_Corp_EmailAddress]=USERPRINCIPALNAME()
|| [Person_EmailAddress]=USERPRINCIPALNAME()
),
FILTER ( Table, [Person_EmailAddress] = Table[Person_ReportsTo_Email])),
,Table[Person_EmpID]
)
)

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    This is not helping because Person_EmailAdress  = Persons Manager email address

    will not eliminate the manager as he will show up under his manager's name so they will not match