Intersect
Returns a list of elements from a first given list that are also found in the second given list.
Syntax & Usage
- Add the Intersect block to the canvas
- Set the required number of branches
- Drop the required functions onto the branches
Intersect([List A], [List B])
- List A represents an initial listing of elements from a hierarchy.
- List B represents a secondary listing of elements from the same hierarchy
Example
In this example, the first set given is a list of all countries except United States. The second is a range list starting from Canada and ending with United States.
The set produced lists the four countries that were selected in both sets: Canada, France, Germany and United Kingdom:
{Intersect({except({AllMembers([customers].[Country])},{[customers].[Country].[United States]})},Range([customers].[Country].[Canada],[customers].[Country].[United States]))}