Forum Discussion
Power BI Row Level Security Help
I need some help with some Row Level Security DAX formulas in Power BI.
I have a list of Customers below and a filter selection. Some users can see all the data, and some users can only see part of the data.
Let's say I'm Customer A. Customer A can see everything on the Customer and Performance column, but the Root Cause and Sales fields need to be blank.
Example of secuirty for selecting Customer A. Notice the blank rows.
To do this I tried relating two tables then writing some DAX filtering expressions using Manage Roles. However it seams the Manage Roles feature only let's you filter out data and I end up loosing all of the other values.
What I ended up doing was using a SWITCH function. I created a new column for each role, then a Measure to Switch between the columns depending on the role.
Measure = SWITCH(SELECTEDVALUE('Table'[Switch]),"A",MAX(Security[Root_Cause_A]),"B",MAX(Security[Root_Cause_B]),MAX(Security[Root Cause]))Here is what the Switch table looks like. I then assign role level secuirty to select a single row in the Switch table.Here is what the table looks like viewing as Customer B. Notice how the Measure field is blank for all Customers except Customer B.
3 Replies
What I ended up doing was using a SWITCH function. I created a new column for each role, then a Measure to Switch between the columns depending on the role.
Measure = SWITCH(SELECTEDVALUE('Table'[Switch]),"A",MAX(Security[Root_Cause_A]),"B",MAX(Security[Root_Cause_B]),MAX(Security[Root Cause]))Here is what the Switch table looks like. I then assign role level secuirty to select a single row in the Switch table.Here is what the table looks like viewing as Customer B. Notice how the Measure field is blank for all Customers except Customer B.
