Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

As you know, it's "Row" level security.

 

You want to show blank in column value for different customers.

 

I think you can try to make it in DAX, something like:

 

measure = if(username() = "A", if(customer_name = username(),customer_name,blank()))

 

Aiolos Zhao

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.