Forum Discussion

DataSundowner's avatar
DataSundowner
Helper 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] )
v-henryk-mstf's avatar
v-henryk-mstf
Community Support
3 years ago

Hi DataSundowner ,

 

For data without a locationID (nulls) in the fact table. for the presence of other fields in the fact table, I think we should try to add a judgment condition to the formula to achieve this requirement.


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • DataSundowner's avatar
    DataSundowner
    Helper II
    3 years ago

    Hi Henry. Thank you for your reply. Please see the screenshots below. My goal is to allow everyone in RLS table to be able to see data with null locationID in the fact table.