https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Inner-Join/m-p/900162#M8216 <P>Sounds like a job for INTERSECT()</P><H1>INTERSECT</H1><P>Intersection of two tables, retaining duplicates.</P><H2>Syntax</H2><DIV class="codeHeader"><SPAN class="language">DAX</SPAN><SPAN>Copy</SPAN><DIV class="successful-copy-alert is-absolute has-right-zero has-top-zero has-left-zero has-bottom-zero is-flex has-flex-align-items-center has-flex-justify-content-center has-text-success-invert has-background-success is-transparent">&nbsp;</DIV></DIV><PRE><SPAN class="hljs-built_in">INTERSECT</SPAN>(&lt;table_expression1&gt;, &lt;table_expression2&gt;) </PRE><H3>Parameters</H3><DIV class="table-scroll-wrapper">Term Definition <TABLE><TBODY><TR><TD>Table_expression</TD><TD>Any DAX expression that returns a table.</TD></TR></TBODY></TABLE></DIV><H2>Return value</H2><P>A table that contains all the rows in table_expression1 that are also in table_expression2</P> Wed, 15 Jan 2020 03:56:00 GMT kentyler 2020-01-15T03:56:00Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Inner-Join/m-p/898648#M8172 Hi<BR />What is the DAX command for this scenario?<BR />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 Tue, 14 Jan 2020 01:20:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Inner-Join/m-p/898648#M8172 mkathi0405 2020-01-14T01:20:43Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Inner-Join/m-p/900162#M8216 <P>Sounds like a job for INTERSECT()</P><H1>INTERSECT</H1><P>Intersection of two tables, retaining duplicates.</P><H2>Syntax</H2><DIV class="codeHeader"><SPAN class="language">DAX</SPAN><SPAN>Copy</SPAN><DIV class="successful-copy-alert is-absolute has-right-zero has-top-zero has-left-zero has-bottom-zero is-flex has-flex-align-items-center has-flex-justify-content-center has-text-success-invert has-background-success is-transparent">&nbsp;</DIV></DIV><PRE><SPAN class="hljs-built_in">INTERSECT</SPAN>(&lt;table_expression1&gt;, &lt;table_expression2&gt;) </PRE><H3>Parameters</H3><DIV class="table-scroll-wrapper">Term Definition <TABLE><TBODY><TR><TD>Table_expression</TD><TD>Any DAX expression that returns a table.</TD></TR></TBODY></TABLE></DIV><H2>Return value</H2><P>A table that contains all the rows in table_expression1 that are also in table_expression2</P> Wed, 15 Jan 2020 03:56:00 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Inner-Join/m-p/900162#M8216 kentyler 2020-01-15T03:56:00Z