Forum Discussion

DataSundowner's avatar
DataSundowner
Icon for Helper II rankHelper II
3 years ago
Solved

RLS Retain Null Values for All Users

Hello everyone. I have a fact table with LocationID and a location dimention table that connects to LocationID in the facts table. Then I have a RLS table that has locationID and user email, and I'm ...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    3 years ago

    Hmm, try it like this.

    VAR _UPN = USERPRINCIPALNAME ()
RETURN
	'LocationDim'[locationID]
	IN CALCULATETABLE ( DISTINCT ( 'RLS'[locationID] ), 'RLS'[Email] = _UPN )
	|| ISBLANK ( 'LocationDim'[locationID] )
jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
3 years ago

Hmm, try it like this.

VAR _UPN = USERPRINCIPALNAME ()
RETURN
	'LocationDim'[locationID]
	IN CALCULATETABLE ( DISTINCT ( 'RLS'[locationID] ), 'RLS'[Email] = _UPN )
	|| ISBLANK ( 'LocationDim'[locationID] )