RLS based on Category

[prajaktakeni11]

Hello ,
I have employee data with different role , I want to restrict data based on Resource type
for example Employee (1) has resource type A and is location head can view only his data being a location head and related resource data fromsales  table 

can you please help 

[prajaktakeni11]

I do have a Refrence Table , with USERNAME we are mapping it to Resource Type 

[lbendlin]

Needs to be USERPRINCIPALNAME.  their email address, basically.

[prajaktakeni11]

@lbendlin  Can't we do it with employee id USERNAME()......?,
and Could you please help me out on dax how can I restrict data based on Type for specific People

[lbendlin]

For dynamic RLS you don't need anything else, but it must use USERPRINCIPALNAME, and your reference table must control the fact tables of the data model.

[prajaktakeni11]

Okay and what would be my dax to filter the data as per specific category ?

[lbendlin]

There is no DAX filter, this is all controlled via the data model.

[lbendlin]

I assume you have a reference table in your data model that maps USERPRINCIPALNAME to resource type?