RLS Not Displaying Visual due to Join Paths

[Anonymous]

Hi guys,

trying to create RLS security, but when I try to view as the user, all my visuals give me an error code. The RLS security formula is based on the "Location Master Data" table. See below.

What should be my next steps? 

[v-lili6-msft]

HI,@sam514 

    After my research, You can change Cross filter direction to single when creating the relationship

between Total sales and Facts orders. and then it will ok.

here is the reference:https://community.powerbi.com/t5/Desktop/Join-paths-and-relationship/td-p/278754

Best Regards,

Lin

[Anonymous]

@v-lili6-msft

Hi there,

When changing the cross filter direction to single, I get an error code: "You can't create a direct active relationship between Facts Orders and Total Sales because that would introduce ambiguity between tables Total Sales and Product Details. To make this relationship active, deactive or delte one of the relationships between Total Sales and Product Details first." 

Let me know! Thanks.