Forum Discussion
Solved
Dax required for RLS to view direct reportees
Hi Team, Please help me with the dax expression for fetching the employee and his direct reports throught RLS I have table called "employee table" with below columns empid, name, managerid, sup...
Hi LP280388 ,
You can use this dax to do the filter:
[empid] in CALCULATETABLE ( VALUES ( 'table'[empid] ), FILTER ( 'table', [supervisorid] = USERNAME () && [ismanager/supervisor] = 0 ) )Result:
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
