I've recently been at a couple of Power BI Conferences where one of the topics which generated some confusion to Citizen Power BI Developers was Dynamic Row Level Security and the DAX related to it. In this article, I will explain it in a very easy and understandable way, and go through every used function step by step.
As it's not possible to view the model and formulas online, neither publish to web with active RLS, I suggest the following:
- Download the PBIX. This will enable you to see the underlying model, formulas, and view as another person.
- Make sure to read the blog post here. It will show you the DAX formulas step by step.