Comparing 2 columns for matches

Hi bjanzen,

Based on your description, you want to compare column Subnets in two tables row by row, right?

To achieve your requirement, please follow steps below:

1.Create index column in two tables, click Edit Queries->Add Column->Index Column.

2.Create relationship between two tables based on index column, click Manage Relationships->New->Select index column in table1->Select index column in table2->One to One and Both direction->Make this relationship Active->Apply security filter in both directions.

3.After a relationship has been built, you can create a measure two compare two columns of different table:

Compare = IF(Table1[Subnets] = RELATED(Table2[Subnets]), 0, 1)

4.Then calculate the number of matched Subnets and unmatched Subnets using DAX formula below:

Number Of True = CALCULATE(COUNT(Table1[Index]), FILTER(Table1, Table1[Compare] = 0))
Number Of False = CALCULATE(COUNT(Table1[Index]), FILTER(Table1, Table1[Compare] = 1))

5.In final, create a pie chart to compare number of Subnets in two table like below:

You can refer to the sample PBIX file here: https://www.dropbox.com/s/3rzo88hjpi7lx5t/For%20bjanzen.pbix?dl=0

Best Regards,

Jimmy Tao