Forum Discussion

Calvin69's avatar
Calvin69
Icon for Helper III rankHelper III
3 years ago
Solved

RLS with Blanks

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 c...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Calvin69 , Try like

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

Calvin69's avatar
Calvin69
Icon for Helper III rankHelper III
2 years ago

HI RobinSellow , do you have a sample file that you could share with us to work this out?

RobinSellow's avatar
RobinSellow
Frequent Visitor
2 years ago

Hi all,

 

Here is how my dataset is built. I have a RLS table with user names, emailadressess and regions (id's). Every user may see an other region, so the dataset if filtered at region level. My RLS table is connected with the region table. The region table is connected with the facilitites table. Because in the region, there are multipe facilities active. And the facilities table is connected with the services table. In this table all the services are mentioned. A service can be fulfilled, then the column declaration_id is filled, but if a service is not fulfilled, than this cell is blank. But this information is also in the dashboard. The problem is that RLS is not showing blank cells, and now my data is not right. 

How can i fix this?