Hi All,
I’m new to using and implementing RLS and require some assistance.
I have a star schema data model setup and all table relationships are 1 to many. Where cross filtering is required, I have avoided using the Bi directional physical table relationships and instead used them in my measures.
However when I use the RLS I get an error:
This is the DAX code i used at the main lookup table (Apps Table) from where everything is joined
[App ID] IN SELECTCOLUMNS (
FILTER (
'Apps User Join',
'Apps User Join'[User ID]
= LOOKUPVALUE ( User[User ID], User[User ID], USERNAME())
),
"App ID", 'Apps User Join'[App ID]
)
Thanks