Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

How to apply specific RLS to different visuals?

Hi! I would like to apply different RLS based on certain visuals. When having 2 visuals, Visual 1 should only show the viewer's own data. Visual 2 should show them their data and everyone who reports...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous ,

     

    I can't reproduce your mistake.

     

    My measures are of the WHOLE NUMBER type.

     

    There is another way to create two new measures:

    CurUserMetric = 
    CALCULATE (
        SELECTEDVALUE ( 'Table'[Metric] ),
        FILTER ( 'Table', 'Table'[EMPL] = USERPRINCIPALNAME () )
    )
    CurUserAndManagerMetric =
    CALCULATE (
        SELECTEDVALUE ( 'Table'[Metric] ),
        FILTER (
            'Table',
            SELECTEDVALUE ( ( 'Table'[EMPL] ) ) = USERPRINCIPALNAME ()
                || SELECTEDVALUE ( ( 'Table'[Manager] ) ) = USERPRINCIPALNAME ()
        )
    )

     

    Dragging these two measures to the two visual objects to replace the [Metric] also fulfills the requirement, and this method does not need to set the Filter.

     

    If the problem is still not solved, please provide a Power BI Desktop file in progress (with sensitive information removed) that fully covers your issue or question in a usable format (not a screenshot). You can upload the PBIX file to a cloud storage service such as OneDrive, Google Drive (set up public access), SharePoint, or a Github repository, and then share the URL of the file.

     

    The pbix file is attached.

     

    If you have any other questions please feel free to contact me.

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!