Bridge table not Cross filtering correctly

v-chuncz-msft

Hi thank you for your reply.

This does work in some cases, when the fileds have similar values on both fact tables.

For exmaple in this case there may be Countries on left fact table and have a Forecast value, but they do not exist on the right Fact table.

Forecast Tables                       BRIDGE TABLE                             Sales Tables

P2     Country                          P2                                               P2 Country

12    ASPAC                            12                                               12  ASPAC

14    EMEA                              14                                               14 EMEA

16    NORTH                            16                                              

Hence,

If i do set one of the Cross filter to BIDIRECTIONAL for example if set P2_Unique (one of my birdge tables which contains a list of ALL my Unique P2 from both Forecast and Sales table) to bidirectional from P2_Unique to my Sales Fact table.....

Then I use P2_Unique in my filter pane......Also I use Country_Unique from Sales Fact table.....then when I filter a particular P2, in my filter pane = 16, under Countries I can see nothing, since the P2 16 exists in the other table .......