Multiple level of Access in single Role category

[Anonymous]

HI All,

I require five level of access in my report with Admin role, it should also be maintained by one single table and i should have a single role category as well.

Lets say i require Vertical, Client,Geo,jobcode and Admin role, but i will not be adding hierarchies as entries in my configuration table i will enter only the required value. for eg:

This the hierarchieal entry which user might not be able to update

User	vertical	Client	jobcode	Geo	SpecialRole
abc@org.com	Tech	Micosoft	100	India
def@org.com					Admin

This the expected data provided from the user

User	vertical	Client	jobcode	Geo	SpecialRole
abc@org.com	Tech
def@org.com					Admin

1. Above user abc when he log's in he supposed to view All Client,Jobcode and Geo Under Tech vertical

2. The challenge is to overcome blank values and achieving Admin role (overall access) in single role category.

Help me to achive this functionality

Thank in Advance.

[Anonymous · Accepted solution]

Hi Bhavani,

Here you go, please add the same logic for your other dimensions as well.

(CONTAINS (
Config,
Config[User],
UserPrincipalName(),
Config[SpecialRole],
"Admin"
)
||
CONTAINS (
Config,
Config[User],
UserPrincipalName(),
Config[Geo],
[SD Geo]
))
||
if(CALCULATE(firstnonblank(Config[Geo],""),FILTER(Config,Config[User]=
UserPrincipalName()))="" && CALCULATE(COUNTROWS(Config),FILTER(Config,Config[User]=USERPRINCIPALNAME()))>=1 ,true,false)

Hope it helps..