Filter Dimension Table of second Fact Table from Dimansion Table of first Fact Table

[question57]

Hey I am tryin on Filtering a Dim Table from another Dim Table but they are not Connected to the same Fact table instead the Fact tables are Connected over a other Dimension Tables which at first had a nm Relation that i dissolved.

The picture below may explain a bit more 🙂 any help is appreciated.

Black is the Table that should specify the Filter(External Document No)

Green is the Path the Filter should Take.

Red is the table that should be Filtered.

[v-rzhou-msft]

Hi @question57 ,

Here I suggest you to try to use both direction in some relationship to make [ZHG$Sales Header] be available to filter

[ZHG$Sales Price].

Accordinhg to your screenshot, I need  to change the relationship between 

1. [ZHG$Document Line History] and [ZHG$Sales Shipment Header]

2. [ZHG$Sales Shipment Header] and [nm_MDPG_ZHGSSH] 

from single to both.

Best Regards,
Rico Zhou

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

[question57]

Indeed, I thought about that, but I did not want to use Bidirectional relations because if I use them always if I Filter the [Document Line History] Table the Filter is automatically handed over to the [Sales Price] table, but I only want this in specific cases. Is there no way to solve this with a Measure