I have a table, and a calculated table which is just: FILTER ( 'Table' , 'Table'[IsCurrent] = TRUE () )
I have to use DAX to apply RLS on this dimension? Should the code go into the Table or the calculated table? Is there any difference?
I refer to this:
I was 100% the same, but apparently the filter in RLS doesn't go through to the calculated table, it only filters the base table, strange!!
I think The Table and that RLS will filter that table and directly filter the Calculated related table.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos✌️!!
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.