Inner Join

[mkathi0405]

Hi
What is the DAX command for this scenario?
Let's say I have a large dataset where the two tables are merged via left join. Then I plotted a network diagram based on one variable A from left table against another variable B from the right table (not to be confused the variables are taken from the large merged dataset). Then I have a filter funnel on another variable. The result was a condensed network diagram with some common links between variable A and B. How to sieve out what are those items in variable A and B are common? Thanks

[kentyler]

Sounds like a job for INTERSECT()

INTERSECT

Intersection of two tables, retaining duplicates.

Syntax

DAXCopy

INTERSECT(<table_expression1>, <table_expression2>)  

Parameters

Term Definition

Table_expression

Any DAX expression that returns a table.

Return value

A table that contains all the rows in table_expression1 that are also in table_expression2