Forum Discussion
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 l...
That did not work either for our table structure. I got it working with the nested and ...I need to work on adding in NPI still.
VAR RPT_GRP_TWO =
CALCULATETABLE (
VALUES (SecurityAccess[RPT_GRP_TWO]),
SecurityAccess[USER EMAIL] = USERPRINCIPALNAME()
)
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 RPT_GRP_TWO,
DimDeptClarity[Area] IN RPT_GRP_TWO
),
(AND (
OR (
"ALL" IN DEPT_ID,
DimDeptClarity[Department Id] IN DEPT_ID
),
OR (
"ALL" IN Specialty,
DimDeptClarity[Specialty] IN Specialty
)
))
)