Forum Discussion
Help required in DAX
Here I want to filter data depends on role id.If I add slicer for both tables on role id data is not filtering in Z_roles table as direction is diffrent.is there any way to filter Z_Roles table irrespective of direction of relationship.(Both direction relationship is not prefred as security roles).So any chance in DAX formaula to filter data in Z_Roles table when we have slicer on user_role table?
4 Replies
Anonymous look at my blog post on RLS and it can help you to make the solution.
https://perytus.com/2019/12/25/how-to-set-default-value-of-single-select-slicer-using-rls/
Anonymous
Drag measure below to Visual level filters and set Show items when the value is 1.
Measure = IF ( SELECTEDVALUE ( Z_roles[role id] ) IN VALUES ( user_role[role id] ), 1 )
