Forum Discussion
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...
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 KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-kongfanf-msft,
We have to compare the Rank too based On the score (It is defined with multiple fact tables.)
Note: Agent Table connect with Multiple Fact table and when we applied the Row Level security it is filtered the data and for other User are filtered out.
Thanks & Regards,
Venkat.