Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 irres...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I guess m scenario is diffrent from what yu have mentioned in your blog.Please correct me if Im wrong.

 

I neeed Z_Roles table value get filter with user_role table irrespective of relationship direction with the help of DAX .I need DAX formula to acheive this.

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    6 years ago

    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 )

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      We are not suppoesed to use visual level filter.

       

      I there any way t handle filtering of data in many to one relationship without enabling cross filter on both sides.Can we achieve same in DAX scripts?

       

      Please suggest me on this.