Troubleshooting slow DAX

Anonymous — Tue, 31 Jan 2023 10:24:40 GMT

I have the below code in RLS that is making my report extremely slow:

What am I doing wrong?

Role1:

Employee table:

=[NT Username] = USERNAME()

Projects table:

=[Key_Project] IN SELECTCOLUMNS( FILTER( 'Engagement Role' ,'Engagement Role'[UserName] = USERNAME() ) ,"Key_project" ,'Engagement Role'[Key_project])

Role2:

Employee table:

=[TeamLeadEmployeeID] IN SELECTCOLUMNS( FILTER( 'Employee Current' ,'Employee Current'[NT UserName] = USERNAME() ) ,"RLS_Ids" ,[Employee Number])

Projects table:

= VAR MyEmployeeNumber= SELECTCOLUMNS( FILTER( 'Employee Current' ,'Employee Current'[NT Username]=USERNAME() ) ,"EmployeeNumber" ,'Employee Current'[Employee Number] ) VAR My_Employees = SELECTCOLUMNS( FILTER( 'Employee Current' ,'Employee Current'[TeamLeadEmployeeID] = MyEmployeeNumber ) ,"EmployeeNumber" ,'Employee Current'[Employee Number] ) RETURN [Key_project] IN SELECTCOLUMNS( FILTER( 'Engagement Role' ,'Engagement Role'[Employee Number] IN My_Employees ) ,"Key_project" ,'Engagement Role'[Key_project] )

topic Troubleshooting slow DAX in DAX Commands and Tips

Troubleshooting slow DAX