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