cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
SSIIntern Regular Visitor
Regular Visitor

Alternative to UserRelationship

Hello, 

 

I've recently implemented RLS and now my measures using UseRelationship have to be replaced. 

 

I've tried duplicating the table and setting two active relationships, but my main problem is that due to the cross-filtering on the active relationships my data is filtered and the numbers are no longer accurate. An inactive relationship does not fitler my data, so UserRelationship was ideal.

 

I'm open to any suggestions and thank you for your time!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Alternative to UserRelationship

@SSIIntern ,

I've tried duplicating the table and setting two active relationships, but my main problem is that due to the cross-filtering on the active relationships my data is filtered and the numbers are no longer accurate. An inactive relationship does not fitler my data, so UserRelationship was ideal.


Yes, RLS will not be affected by inactive relationship. So I'm afraid the only is to reconstruct the table relationship between the tables without using cross-filtering.

 

Community Support Team _ Jimmy Tao

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

3 REPLIES 3
ThomasFoster Established Member
Established Member

Re: Alternative to UserRelationship

I dont know how it interacts with RLS but you could try using TREATAS to create a virtual relationship

 

https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/ 

SSIIntern Regular Visitor
Regular Visitor

Re: Alternative to UserRelationship

TREATAS doesn't quite solve my problem but I appreciate your help. 

Community Support Team
Community Support Team

Re: Alternative to UserRelationship

@SSIIntern ,

I've tried duplicating the table and setting two active relationships, but my main problem is that due to the cross-filtering on the active relationships my data is filtered and the numbers are no longer accurate. An inactive relationship does not fitler my data, so UserRelationship was ideal.


Yes, RLS will not be affected by inactive relationship. So I'm afraid the only is to reconstruct the table relationship between the tables without using cross-filtering.

 

Community Support Team _ Jimmy Tao

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