Showing results for 
Search instead for 
Did you mean: 
Post Patron
Post Patron

DAX for rls on table or its calculated table?

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:





Post Patron
Post Patron

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!!

Community Champion
Community Champion

Hi @ovonel 


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✌️!!



Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.