Dax measure - Finding overlap between portfolios

[SLDAX]

Hi Community. 

Im working a project where I want to analyse if a given asset is in multiple portfolios. 
The picture below illustrates what im trying to accomplish. 

Can I write a measure that filters the table, so the resulting table consist of all the yellow rows? 

Name of Portfolio and Asset Code is in two different tables. 

The values is market value, which is a measure. 

Hope someone can help me out.

[Anonymous · Accepted solution]

[# Assets In 2+ Portfolios] =
SUMX(
	// You have to iterate over
	// a column that uniquely
	// identifies Assets.
	DISTINCT( Assets[AssetID] ),
	CALCULATE(
		// Same as above for Portfolios
		1 * ( DISTINCTCOUNT( Portfolio[PortfolioID] ) > 1 ),
		FILTER(
			DISTINCT( Portfolio[PortfolioID] ),
			[Market Value]
		)
	)
)

Use this measure in the Filter Pane to filter the rows of the visual. For one visible asset it should return 1 only if the asset is in at least 2 different portfolios (as visible in the current context, of course).

[SLDAX]

It was exactly what I needed. Thanks for your assistance.