Report Sharing

Hi Zakaria_1980 

In addition to amitchandak 's reply. You may need to build a User Table and use dynamic RLS to achieve your goal.

I build a sample for you.

Data Table:

Build a User Table as below.

Manage Role in Modeling.

[Market] = 
CALCULATE (
    MAX(Data[Market]),
    FILTER (
        User,
        User[Account] = USERPRINCIPALNAME()
            && User[Market] = Data[Market]
    )
) 

Then publish this report to service and add roles in Security in Dateset.

For more details you may refer to aj1973's Blog.

Result is as below.

If I read the report as User A, I can only see the values for Market1 that I belong to.

Best Regards,

Rico Zhou

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