Forum Discussion

zq's avatar
zq
Frequent Visitor
9 years ago

Power BI Embedded Row-Level Security for Multiple values of single attribute

Hi all, I have embedded a power report with one role i.e. department_id. When a user accesses the report, the report is filtered according to the department_id to which he has access. This id is pass...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous zq RajeshAHCUSA 

What you need to do is use CALCULATE to evaluate the expression for each row of the table, creating a row context for each row and filtering the data to match on a single value. I believe somthing like this would work:

 

='Table[DeptId]=
CALCULATE(
VALUES(Security_Table[DeptId])|  ----> obtain list of values
SUMMARIZE(Security_Table|Security_Table[ADAccountName])| ----> grouped by the member
Security_Table[ADAccountName] = USERNAME() | ---> first filter matches the member to Directory
FILTER(Security_Table|Security_Table[DeptId] = EARLIER('Table[DeptId]))  ------> Second Filter pulls value that matched the row
)

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Anonymous do you mean adding a new column for each, in this case, user with a 'CALCULATE' evaluation like the one you posted ? 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Anonymous ,

       

      You don't need a column to do this. You can use the code in the DAX Filter under the role manager and assign it to the table you're wanting to filter.

       

      Thanks