Help required to implement security via a user information table
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] = "[email protected]") -- 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
