Help required to implement security via a user information table

[stuti]

I have use case where in user should be able to filter and view data by a

security matrix

     

User Information table  

The report is expected to identify the current logged in user and accordingly filter the data in the report by conditions verified by security matrix and available as in user information

Example:

Tom being a Team Head should be able to 

1. see all Jurisidction applicable when Team - Engineer 

2. see only Engineer as the value in Slicer for Team whereas all values for Jurisdiction slicer when blank 

Slicers are sourced from dimension tables Team & Jurisdiction.

I have tried to create measure that captures values individually for team & jurisdiction for the logged in user via USERPRINCIPALNAME() however this works well to filter out the slicers but not on visuals that include Field Parameters aka combination of attributes.

User Team =

VAR _Team =

CALCULATETABLE(

    VALUES(UserInfo[Team]),

    UserInfo[User] = "Tom@abc.com") -- to be changed to USERPRINCIPALNAME()

RETURN

IF( VALUES(Team[Team]) IN _Team,1,0)

Welcoming any suggestions on data modelling or approaches or ideas to implement it.

Link to sample pbix for reference - Sample PBIX 

Thanks

[v-zhangti]

Hi, @stuti 

Please refer to the following links in the hopes of helping you.
Solved: Dynamic RLS - Microsoft Power BI Community

Row Level Security with SSAS Tabular Live Connection in Power BI - RADACAD

Best Regards,

Community Support Team _Charlotte

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