Forum Discussion
Filtering directly on a count measure
So I have two tables which I want to compare using a slicer which has the options of "Difference", "Common", "All" Table1 Venue Code Venue Name Customer Code Laguna Suria 101Suria L...
lbendlin
Super User
Super UserThere are built-in functions in DAX for this
INTERSECT() - commonalities
EXCEPT() - differences
UNION () and SUMMARIZE() - all
Note: You have duplicate rows in each table. The results of the Venn Diagrams will be skewed. Better to have unique row identifier columns.