How to get filtered related fact table?

[Anonymous]

There are a large (LargeTable) and small (SmallTable) fact tables. They are not connected directly, but have common dimensions (DateId, CustomerId, CategoryId).

I would like to start writing DAX query from getting LargeTable items that has connections to the SmallTable items.

 Probably, I should use SUMMARIZE and RELATEDTABLE commands, but I can't figure out how to combine the query.
Could you please help me with this problem?

[lbendlin · Accepted solution]

You can't actually do that unless your fact tables have bidirectional search enabled against the dimension table (which is not really recommended).  Just use measures, or TREATAS()