Forum Discussion

basirve's avatar
basirve
Icon for Helper III rankHelper III
2 years ago
Solved

Dynamic Row level security Overriding My Dax Formula

Dear Experts, I have agent scorecord report and want to implement Dynamic row level Security. Hierarchy is : Agent --> Supervisor --> Manger --> Director When Agent Login and he can able to his da...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi basirve ,

     

    You can compose a new table of people information as a slicer and create a MEASURE similar to the following:

    result_ = 
VAR sel_ =
    SELECTEDVALUE ( Slier[Person] )
RETURN
    IF (
        sel_ = MAX ( Test[Agent] ),
        [result_Agent],
        IF ( sel_ = MAX ( Test[Manger] ), [result_Manger], BLANK () )
    )

    Best Regards,
    Adamk Kong

     

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi basirve ,

 

You can compose a new table of people information as a slicer and create a MEASURE similar to the following:

result_ = 
VAR sel_ =
    SELECTEDVALUE ( Slier[Person] )
RETURN
    IF (
        sel_ = MAX ( Test[Agent] ),
        [result_Agent],
        IF ( sel_ = MAX ( Test[Manger] ), [result_Manger], BLANK () )
    )

Best Regards,
Adamk Kong

 

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