Showing results for 
Search instead for 
Did you mean: 
New Member

Userrelationship and Role Level Security Issue

Hi All,


I have already read a couple of blogs on this issue and am still unable to resolve this issue completely


To give the overview of my problem. I have the following model:designmodel.JPG

DimName and DimSurname are the filters on my dashboard. I have 2 types of measures

1. Measures that userelationship with NameA->Name and SurnameA->Surname, and

2. Measures that userelationship with NameB->Name and SurnameB->Surname


In addition I have role level security applied to the DimName, DimSurname and Fact


If I use "Userelationship" I get error which is a known limitation of tabular model (Chriss Webb's blogpost:


I tried to use Virtual Relationship using FILTER ALL and CONTAINS ( Marco's post  )


This works fine but it fails to override the active relationship: For the measure below for eg:


           'Fact'[ID]<> BLANK(),
            FILTER (
                        ALL ( 'Fact'[NameB] ),
                        CONTAINS (
                                         VALUES ( 'DimName'[Name] ),
                                         'DimName'[Name] ,

The active Filter is based on NameA and the above measure is not able to override NameA filter (Even if I use ALL ( 'Fact'[NameA] inside Filter or outside )


Is there any way to override the Filter here or in general can you suggest the optimal/best approach to solve this issue? (For example having 2 different Fact Tables with simplified relationships to the 2 Dims)



Community Support
Community Support

Re: Userrelationship and Role Level Security Issue

Hi @sarafparam,


In my opinion, I'd like to suggest you split fact table to different tables or try to merge similar columns to one.

Unpivot Data Using Excel Power Query

Power bi not support dynamic active relationship and apply them to RLS.



Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors