RLS with Blanks

[Calvin69]

Hi experts,

I have a report that uses the RLS feature.

I established an external Excel sheet that lists all users names, emails, departments & Projects and linked to my code in RLS:

In the current finance system "Data Source" we use dimenisons with our transactions, some transactions are tagged with Dept. or Project dimension values and some are not "no dimensions = Blank".

The problem I am facing when using the setup mentioned above is that all users are only able to see entries related to their permission within the excel sheet "Sample below" any none dimension related entries are not showing to them. As you can see below, each user do have a "Blank" cell in both Dept. and Project column but for some reason the dax code is ignoring all blanks.

Example of the pemrission matrix:

Name	Email	Department	Project
Bob	Bob@H.com	A
Bob	Bob@H.com	B
Bob	Bob@H.com		K
Dan	Dan@H.com	H
Dan	Dan@H.com		C

Is there a way for me to allow all users to see data based on their RLS setup and all Blanks "meaning entries with no dimensions?

Thanks

H

[Calvin69]

@amitchandak Nailed it mate, Thank you loads....

[amitchandak · Accepted solution]

@Calvin69 , Try like

[email] = userprincipalname() || isblank(Table[department Project])