Filtering two unrelated fact tables (summing up categories/values between unrelated tables)

[Anonymous]

Hello Community  -  I'm not clear how to go about this.   Our company recently received back some survey responses for NPS scoring.  

My data model is below.    Ideally, I'd really to like to be able to slice and dice my Retently survey customers against my sales and shipments tables.    Is there some specific DAX that can accomplish this?    Given I don't have a direct relationship between those tables, I'm hoping there is some type of DAX pattern that would allow me to filter my customers that returned an NPS survey, but other fields on the orders and fact tables.  

For example, filtering all "Promoters" (from Retently table) by their total sales dollars (on the sales orders table).    Or filtering the Retently survey customers by a certain product on the sales orders table.  

Any help is much appreciated!

[Anonymous]

@lbendlin   Perfect.  I just watched one of RADACAD's videos on this and it happend to exactly match the scenario I'm working with.   

[lbendlin · Accepted solution]

You can create measures that temporarily change the cross filter to BOTH on one of the fact tables.

CROSSFILTER function - DAX | Microsoft Docs

That will allow you to "get there from here"  for each of these question scenarios.