Conditional/Multi-Layered Row-Level-Security
Hi Power BI Community, I am having trouble figuring out a multi-layered, dynamic RLS problem. Essentially, I have a table of transactions and employee email adresses. I also have another table of employee emails and their departments. Depending on which department the user belongs to, I want to provide them with either: Access to their own transactions only Access to 1 or more department's transactions How do I go about implementing this?
How to keep original values in a rankx measure and apply it on table with role level security?
Hi all, I have a table like this: The rank column in this created table is a caluclated measure that displays the ranking of each employee filtered by their channel and based on their total score: Rank Employee = RANKX( ALL('table1'[Employee]), [Total Score] ) This works fine. However, the table will be viewed by individual employees to see only their performance and I need to hide other employees rank and scores. Right now, this is how the 2nd ranked employee from channel a views the table: It is showing his rank as 1 when it should be 2. Similarly, all employees view their rank as 1st. Thus, how do i keep the original rank values even when there is role level security view being implemented?
Role Level Security Dax Measure - looking at different fields to determine access
I have a security table that indicates what level a person can access data. I am trying to build the Dax filter in the Roles to make it apply secuirty at differnt levels. Below I got it working to look at department or specialty but I am stuck how to write this for RPT_GRP_2 and NPI levels. Total newbie to Power bi and Dax so if their is better way to write this metric I am open to suggestions VAR Specialty = CALCULATETABLE ( VALUES (SecurityAccess[SPECIALTY]), SecurityAccess[USER EMAIL] = USERPRINCIPALNAME() ) VAR DEPT_ID = CALCULATETABLE ( VALUES ( SecurityAccess[DEPT_ID] ), SecurityAccess[USER EMAIL] = USERPRINCIPALNAME() ) RETURN AND ( OR ( "ALL" IN DEPT_ID, DimDeptClarity[Department Id] IN DEPT_ID ), OR ( "ALL" IN Specialty, DimDeptClarity[Specialty] IN Specialty ) ) Example of Security Table USER EMAIL USER AREA LEVEL DEPT_ID SPECIALTY RPT_GRP_TWO NPI_ID [email protected] Executive EXEC All ALL ALL ALL Division [email protected] Division Chief CP Specialty ALL Primary Care ALL [email protected] Director CP Mulitiple Specialties ALL ALL Ambulatory [email protected] Manager CP Clinic 1005019 ALL ALL [email protected] Provider CP Provider ALL ALL ALL 12345678
