Showing Error in Manage Role - The end of the input was reached

[ashishg]

While using below dax its showing an error when I want to create a role

FILTER(
ALL('ReportFACT'),
'ReportFACT'[State] IN (
SELECTCOLUMNS(
ALL('StateRLS'),
"State", 'StateRLS'[State],
"Email", 'StateRLS'[Email]
)
 'StateRLS'[Email] = USERPRINCIPALNAME() )
&&
'ReportFACT'[Company] = (
SELECTCOLUMNS(
ALL('CompanyRLS'),
"Company", 'CompanyRLS'[Company],
"Email", 'CompanyRLS'[Email] )
 'CompanyRLS'[Email] = USERPRINCIPALNAME() )
)

@amitchandak , @Greg_Deckler 

[selimovd]

Hello @ashishg ,

what exaclty do you want to do?

There is no WHERE command in DAX, so what you did is not proper DAX code.

Also you have to make sure that the expression returns a boolean value. So it has to return TRUE or FALSE for every row in the specific table.

Best regards

Denis

[ashishg]

@selimovd 
I want to apply RLS for my previou quetion if you suggest me anything it would be helpful
here is link of my previous quetions 

https://community.powerbi.com/t5/Desktop/RLS-security-based-on-State-and-Company-table/m-p/3008649#M...