Forum Discussion
Customer overlap
Hi there - powerbi newbie here.
I have two tables that are structured in exactly the same manner (same columns) - i would like to count the number of overlap between the tables via column that is present in both tables (identification_number)
Is there an easy way to do this?
new table = INTERSECT(distinct(Table1[identification_number]) ,distinct(Table1[identification_number]) )
or have common dim table
distinct(Table1[identification_number]) = distinct(union(distinct(Table1[identification_number]) ,distinct(Table1[identification_number]) ) )
then you can a measure and use with this common dim or as grand total
countrows(INTERSECT(distinct(Table1[identification_number]) ,distinct(Table1[identification_number]) ))
1 Reply
new table = INTERSECT(distinct(Table1[identification_number]) ,distinct(Table1[identification_number]) )
or have common dim table
distinct(Table1[identification_number]) = distinct(union(distinct(Table1[identification_number]) ,distinct(Table1[identification_number]) ) )
then you can a measure and use with this common dim or as grand total
countrows(INTERSECT(distinct(Table1[identification_number]) ,distinct(Table1[identification_number]) ))