Forum Discussion

sarath_chandra's avatar
sarath_chandra
Helper III
3 years ago
Solved

Dax Help

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 use...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.