Forum Discussion

dinesh_digicube's avatar
dinesh_digicube
Regular Visitor
4 years ago

Filtering slicer based on another dimension

Hello,

 

I have a 4 tables having hierarchy like  Location-->City-->Country-->Region

I have another table hierarchy like UserMaster --> UserRights 

In UserRights table there are columns like UserId, LocationId,CityId,CountryId,RegionId

Basically user has been given rights to view data for selected region, country and so  on...

Relationships are as menioned below - 

UserMaster.UserId = UserRights.UserID

UserRights.LocationId = Location.LocationId

 

 

Now, when I am applying filter of UserMaster.LoginId then the slicer of RegionMaster is not filtering based on the selected LoginId.

 

Pls note that these tables are not connected with each other with FACT table however they are connected which each other via indirect relationship like UserMaster --> UserRights--> Location and so on...

 

Can someone help on this. Or is there any alternate solution to achive filtering,

Thanks in advance.

 

 

Need Help

3 Replies

    • dinesh_digicube's avatar
      dinesh_digicube
      Regular Visitor
      4 years ago

      Hi, thanks for your reply.

      In my case fact table is not directly connected , its connected via other table.. So its not working ..

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Community Support
    4 years ago

    Hi, dinesh_digicube 

     

    Without a specific model it is hard to know what went wrong.

    Does it work to change the cross-filter direction to both?

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng

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