Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ashishg
Advocate I
Advocate I

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

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 

2 REPLIES 2
selimovd
Super User
Super User

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

 

@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...

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.