create table visual from multiple facts tables across common dimension table

[Anonymous]

Hi,

I have the following schema:

I use the middle table (dimension) as a filter in my report, as this:

which works fine as long as I display both fact tables (models and data) separately.

But when I combine the fields from both tables into one table, I get:

How can I go around this to display a filtered (cartesian) table with week | model | data?

Thanks

[Anonymous]

Hi @Anonymous

Any particular reason why the cross filter is set to bidirectional ? 

If there is no specific requirement to do so, can you make it one direction ( Weeks to Data  & Weeks to Models) and try?

Thanks
Raj

[Anonymous]

One direction doesn't work either