INTERSECT

INTERSECT Returns the row intersection of two tables, retaining duplicates.


Syntax

INTERSECT(table_expression1, table_expression2)

Parameters

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


Reference Data

https://docs.microsoft.com/en-us/dax/dax-function-reference

DAX Functions / Other Functions / INTERSECT