RLS and userelationship

[Lakshmanan94]

I have a fact table and two dimension table, one is name and other is date. I want to calculate the count of one person's data from two columns in fact table for a given month. I use active relationship from name dimension to fact and date dimension to fact for one of the two data. For second data I use inactive relationship.

Now when I use rls on name dimension, I get error for the measures I used inactive relationship. Please suggest a solution.

[Poojara_D12]

Hi @Lakshmanan94 

RLS does not activate inactive relationships automatically.
Whenever RLS + USERELATIONSHIP are together, use manual filtering logic or bridge table modeling.

If you'd like, share a simplified version of your table structure and measure and I can try to dive into it and help you as much as I can do.

[v-sshirivolu]

Hi @Lakshmanan94 ,

Have you had an opportunity to review the super user’s response? Could you please provide a sample dataset for reference?

[v-sshirivolu]

Hi @Lakshmanan94 ,
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-... 

[KNP · Accepted solution]

Show us your model and provide us some sample data and RLS details.