Joining to a filtered table

Partial solution: don't bother joining to product and subsidiary, use summarize instead of select columns, make multiple tables instead of trying to do it all in one step.

It's only partial because I still can't get Power BI to recognize the relationship between Replenishable and the Product/Subsidiary dim tables.

Maybe I need to create relationships to all the various fact tables instead? (There are a lot - Actuals, CFO Forecast, Demand Planning Forecast, DC Inventory, Stores ISP, and Supply are the ones referenced in my matrix - and they all have their own relationships back to Product and Subsidiary.) But maybe the problem is fundamentally related to direct query tables vs local tables and that won't work either.

Table code:

ReplenishOnly = 
SUMMARIZE (
	FILTER (
		'Stores ISP',
		'Stores ISP'[Stores Replenish] > 0
			&& 'Stores ISP'[SnapshotDate] > TODAY () - 8
	),
	'Stores ISP'[ProductID], 
	'Stores ISP'[SubsidiaryID]
)

ReplenishAll = 
SUMMARIZE (
	'Stores ISP', 
	'Stores ISP'[ProductID], 
	'Stores ISP'[SubsidiaryID]
)
	
Replenishable = 
ADDCOLUMNS (
	'ReplenishAll',
	"Replenishable",
	IF (
		NOT ISBLANK (
			LOOKUPVALUE (
				ReplenishOnly[ProductID],
				ReplenishOnly[ProductID], ReplenishAll[ProductID],
				ReplenishOnly[SubsidiaryID], ReplenishAll[SubsidiaryID]
			)
		),
		TRUE,
		FALSE
	)
)