Filtering slicer based on another dimension

[dinesh_digicube]

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.

[v-angzheng-msft]

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.

[amitchandak]

@dinesh_digicube , You need to use a measure from fact to check the value of the measure is not blank in the visual level filter.

Refer this video - https://www.youtube.com/watch?v=cyOquvfhzNM

[dinesh_digicube]

Hi, thanks for your reply.

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