Modelling-Relationship

[sshiny]

Hi,

Currently, Sales Hierarchy DIM is filtering Tag Usage Fact to Loaner Consign FACT based on tag owner ID.

I would like to know, if there is a way, when the Sales Hierarchy is filtered by zone, it should filter tag usage fact and loaner consign fact based on last location?

[amitchandak]

@sshiny , from where the zone is coming ?

Refer if this can help

How to filter the slicer of a disconnected table: https://youtu.be/cV5WfaQt6C8

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[sshiny]

@amitchandak Zone is coming from the Sales hierarchy DIM