Dax Help

[sarath_chandra]

I have material ,material type (AL,DT,EW) and four region wise(R1,R2,R3,R4) data .Based on region wise user, i have to show the min value of regions.I have to ride the min values for other region users too (for example , region 1 user viewing the report means it should the min value of region 1 alone and should not show the values of other region).Above (first table is my data source )
i need to achieve second one based on region users

[Anonymous · Accepted solution]

Hi @sarath_chandra ,

You can try to use RLS. Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles. 

More details: Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

You can set Dynamic RLS, you need to have their power bi account in a column.

1. In the RLS, create a role: Email address = userprinciplename()

2. Publish to service, in Security tab add all emails(pbi account) to the role

3. With the above setting, users log into power bi service will only see data in the respective ro

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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

[sarath_chandra]

@FreemanZ @johnt75 @Jihwan_Kim @tamerj1 please please look into it and help me