Managed Role - Filtered data if user has no value against him & without relationship.

[navin_Learning]

Dear All,

This is either very tricy or impossible.

I got 2 table, main table and user table

• user name is not available in main table.
• In user table, user name has code against them in 2 different column
• Link between these 2 table is two columns with different code (FyI, duplicate value exist).

Now i am able to filter the data with the help of these two columns by creating many to many relationship (1 active, 1 inactive) and mentioning in managed role, user=principalname(),

Question: if a user has no value mentioned again them, then full table/report to be displayed, how do i acheive this.

Thank you for your help!

Regards,

Navin Ghai

[lbendlin]

You can use measures and TREATAS  (even without relationships between the tables)

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...