DAX on RLS

[jimen]

Hi all, I wanted to make relationship between the security table and the fact table without having the connection in the modelling part. FacSecAccess is the security table. So I'm planning to do RLS role that can filter which email (in table FacSecAccess) that can access particular permission/department in FacPrmsn table that connected to the Data table without having the connection between the FacSecAccess and FacPrmsn. Any idea on how to do this? 

Data and FacPrmsn connection key = DEPT_C

FacPrmsn and FacSecAccess connection key = Prmsn/PRMSN

[v-rongtiep-msft · Accepted solution]

Hi @jimen ,

I have created a simple sample, please refer to my pbix file to see if it helps you.

Create a measure in table FacPrmsn.

Measure = (LOOKUPVALUE(FacSecAccess[e-mail],FacSecAccess[PRMSN],MAX(FacPrmsn[PRMSN])))

Then create a measure in table FacSecAccess.

Measure 2 = FacPrmsn[Measure]

Then create roles.

Then view as the role.

If I have misunderstood your meaning, please provide you pbix file without privacy information and desired output.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.