Dynamic RLS With Multiple Columns in User Table

[inavedk]

I am trying to create a dynamic rls , Here is my RLS code

VAR _RLS_Restriction =
IF (
_Roles IN "Region" && [WH_Region] IN _AllowedRegions,
TRUE(),
IF (
_Roles IN "Project" && [WH_Project] IN _AllowedProjects,
TRUE(),
IF (
_Roles IN "Group" && [Agent_Group_Name] IN _AllowedGroups,
TRUE(),
IF (
_Roles IN "Region-Project" && [WH_Region] IN _AllowedRegions && [WH_Project] IN _AllowedProjects,
TRUE(),
IF (
_Roles IN "Region-Group" && [WH_Region] IN _AllowedRegions && [Agent_Group_Name] IN _AllowedGroups,
TRUE(),
IF (
_Roles IN "Project-Group" && [WH_Project] IN _AllowedProjects && [Agent_Group_Name] IN _AllowedGroups,
TRUE(),
IF (
_Roles IN "Region-Project-Group" && [WH_Region] IN _AllowedRegions && [WH_Project] IN _AllowedProjects && [Agent_Group_Name] IN _AllowedGroups,
TRUE(),
FALSE()
)
)
)
)
)
)
)

RETURN
_RLS_Restriction

Also Role column i have created with this dax

Role =
VAR regionname = [Region]
VAR Project = [Project]
VAR _group = [Group]

VAR _Role =
SWITCH(
TRUE(),
regionname <> BLANK() && Project = BLANK() && _group = BLANK(), "Region",
regionname = BLANK() && Project <> BLANK() && _group = BLANK(), "Project",
regionname = BLANK() && Project = BLANK() && _group <> BLANK(), "Group",
regionname <> BLANK() && Project <> BLANK() && _group = BLANK(), "Region-Project",
regionname <> BLANK() && Project = BLANK() && _group <> BLANK(), "Region-Group",
regionname = BLANK() && Project <> BLANK() && _group <> BLANK(), "Project-Group",
regionname <> BLANK() && Project <> BLANK() && _group <> BLANK(), "Region-Project-Group",
"Other"
)
RETURN
_Role

When a user has a single value passed from a range (i.e., a value in any of the three columns and the rest two columns are blank). The RLS works in this case. However, if I want to add a region or project for that user, it gives an error.

The error message I'm receiving is "The function expects a table instead of a string or numeric expression." Or sometimes if i change some context it was saying multiple values supplied where single value was expected.

Any help or insights on how to resolve this would be greatly appreciated. Thank you!

Here is the user table 

Emnih	Region	PrLjecH	Group	Role
158679@nh.mnmphe.cvm	NETHERLANDS	NLne	None	Group
650309@nh.mnmphe.cvm	NETHERLANDS	NLne	None	Group
650167@nh.mnmphe.cvm	NETHERLANDS	NLne	None	Group
162300@nh.mnmphe.cvm	NETHERLANDS	NLne	None	Group
90474@nh.mnmphe.cvm	NETHERLANDS	NLne	None	Group
10587@nh.mnmphe.cvm	NETHERLANDS	NLne	None	Group
650308@nh.mnmphe.cvm	NETHERLANDS	NLne	None	Group
enic.mnntvm@mnmphe.cvm	FRANCE	NLne	None	Group
enmnntvm@mnmphe.fn	FRANCE	NLne	None	Group
cnnimtvpne.nhhn@mnmphe.cvm	FRANCE	NLne	None	Group
dvminique.vignnnd@mnmphe.cvm	FRANCE	NLne	None	Group
emihiv.cvhhndv@mnmphe.cvm	FRANCE	NLne	None	Group
enic.mnntvm@mnmphe.cvm	FRANCE	NLne	None	Group
gihhem.gunnneh@mnmphe.cvm	FRANCE	NLne	None	Group
jenvme.guihhnumvt@mnmphe.cvm	FRANCE	NLne	None	Group
nnbih.mnidi@mnmphe.cvm	FRANCE	NLne	None	Group
pienne.guimhin@mnmphe.cvm	FRANCE	NLne	None	Group
tnienny.mueun@mnmphe.cvm	FRANCE	NLne	None	Group
jguihhnumvt@mnmphe.fn	FRANCE	NLne	None	Group
jvmefennnndez@mnmphe.em	None	VGRICV - MLNHCEVU	None	Group
jvmefennnndez@mnmphe.em	None	VGRICV PRLJECH SHIELG - MLNHCEVU	None	Group
jvmefennnndez@mnmphe.em	None	VLVN	None	Group
jvmefennnndez@mnmphe.em	None	GLCHLLIB - VIHRé	None	Group
jvmefennnndez@mnmphe.em	None	GLCHLLIB PRL - VIHRé	None	Group
jvmefennnndez@mnmphe.em	None	GLCHLLIB	None	Group
jvmefennnndez@mnmphe.em	None	EGF - CLMPIÈGNE	None	Group
jvmefennnndez@mnmphe.em	None	EGF - CLMPIèGNE	None	Group
jvmefennnndez@mnmphe.em	None	EGF CLMPIèGNE	None	Group
jvmefennnndez@mnmphe.em	None	FGJ CCRV - CLMPIèGNE	None	Group
jvmefennnndez@mnmphe.em	None	FGJ CCSC - CLMPIèGNE	None	Group
jvmefennnndez@mnmphe.em	None	FGJ CCSC VIP - CLMPIèGNE	None	Group
jvmefennnndez@mnmphe.em	None	HISCLX - CLMPIèGNE	None	Group
jvmefennnndez@mnmphe.em	None	INHERIVLE - MLNHCEVU	None	Group
jvmefennnndez@mnmphe.em	None	LMG - CHVLLN	None	Group
jvmefennnndez@mnmphe.em	None	MVVF - FLNHENVY	None	Group
nvnngnm@mnmphe.em	None	VGRICV - MLNHCEVU	None	Group
nvnngnm@mnmphe.em	None	VGRICV PRLJECH SHIELG - MLNHCEVU	None	Group
nvnngnm@mnmphe.em	None	VLVN	None	Group
nvnngnm@mnmphe.em	None	GLCHLLIB - VIHRé	None	Group
nvnngnm@mnmphe.em	None	GLCHLLIB PRL - VIHRé	None	Group
nvnngnm@mnmphe.em	None	GLCHLLIB	None	Group
nvnngnm@mnmphe.em	None	EGF - CLMPIÈGNE	None	Group
nvnngnm@mnmphe.em	None	EGF - CLMPIèGNE	None	Group
nvnngnm@mnmphe.em	None	EGF CLMPIèGNE	None	Group
nvnngnm@mnmphe.em	None	FGJ CCRV - CLMPIèGNE	None	Group
nvnngnm@mnmphe.em	None	FGJ CCSC - CLMPIèGNE	None	Group
nvnngnm@mnmphe.em	None	FGJ CCSC VIP - CLMPIèGNE	None	Group
nvnngnm@mnmphe.em	None	HISCLX - CLMPIèGNE	None	Group
nvnngnm@mnmphe.em	None	INHERIVLE - MLNHCEVU	None	Group
nvnngnm@mnmphe.em	None	LMG - CHVLLN	None	Group
nvnngnm@mnmphe.em	None	MVVF - FLNHENVY	None	Group