RLS Error - The UseRelationship() and CrossFilter() functions are not available in this context.

[ronaldbalza2023]

Hi everyone, when applying RLS, this error showed up. Could someone help me out on this, please 🙂 Thank you!

[amitchandak · Accepted solution]

@ronaldbalza2023 , refer

USERELATIONSHIP cannot be used when row level security is defined for the table in which the measure is included. For example, CALCULATE(SUM([SalesAmount]), USERELATIONSHIP(FactInternetSales[CustomerKey], DimCustomer[CustomerKey])) will return an error if row level security is defined for DimCustomer.

https://community.powerbi.com/t5/Desktop/USERELATIONSHIP-and-RLS/m-p/787463

https://docs.microsoft.com/en-us/dax/userelationship-function-dax