Forum Discussion
Help with RLS for inactive relationships with USERELATIONSHIP
Hi! We would like to use RLS on seller in this testexample with USERPRINCIPALNAME(). The dimension has multiple relationships to the fact table workorders. And from the documentation we ...
I think I have found the solution in this articel from SQLBI
"DAX limitations with inactive relationships and row-level security (RLS)"
https://www.sqlbi.com/articles/dax-limitations-with-inactive-relationships-and-row-level-security-rls/
Hi Anonymous ,
You can modify your formula like below:
# of rows with inactive repationship =
CALCULATE
(
COUNTROWS(Orders)
, USERELATIONSHIP(Seller[Id],Orders[Seller_col2])
)
But note: USERELATIONSHIP cannot be used when defining row-level security for tables containing measure.
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The challenge is that we need to use row-level security for this.