Table filter dax Expression error (RLS)

[Anonymous]

Hi Experts

I am trying to add the following to the manage roles in (RLS) section based on table Permsissions (filter applied to Email Address)

[Email Address] = USERPRINCOPLENAME()

|| [LEVEL 03] = USERPRINCOPLENAME()

|| [CC CODE] = USERPRINCOPLENAME()

Level 03 and Email Address are text column, CC Code is a numerical value...

the error message i am getting is Consider using VALUES or FORMAT funtion to convert one of the values .... question is how do you apply Values or format to the last line || [CC CODE] = USERPRINCOPLENAME()

[parry2k · Accepted solution]

@Anonymous the fundamental issue is the you cannot compare number field with text column, so cc code is number and you can't compare it with USERPRINCIPALNAME() which is text 

As @amitchandak  asked, it is not clear why this is required, share a sample data with the use case where CC Code will be used for RLS. Your sample data doesn't show all the details, like Level 02 column, where is this column?

[amitchandak]

@Anonymous , what is the objective here to do this 

[CC CODE] = USERPRINCOPLENAME()

you can compare email with email not with code

[Anonymous]

My objective to is apply RLS to email based on Email Filter (permission table) - Which links to bidge table via department which link to FACT table via department but ONLY show CC Code that apply to John....in Finance .....we do not have cc code for all department....Hence i was trying to create some sort of hierarchy

See image

[bcdobbs]

Can you send a picture of your model or better a demo pbix file?

[Anonymous]

Hi Bcbobbs - The relationship is Both Between Permission table and the Lookup table based in ID and one to many between Lookup table and FACT table...