build report for records not found in related table

[Anonymous]

I have two tables.  Table one has records 1 thru 10.  Table 2 has records 2,5,7,8,9.  I want to build a report that includes only records not found in Table 2 (1,3,4,6,10).  

How can this be done?

[amitchandak · Accepted solution]

@Anonymous ,

new table = except(all(Table1[Col1]), all(Table2[Col1]))

new measure = countx(except(all(Table1[Col1]), all(Table2[Col1])),[Col1])

[amitchandak · Accepted solution]

@Anonymous ,

new table = except(all(Table1[Col1]), all(Table2[Col1]))

new measure = countx(except(all(Table1[Col1]), all(Table2[Col1])),[Col1])

[Anonymous · Accepted solution]

"Except"  was the way to go!  Created the table exactly as I needed.

[Anonymous]

should be very easy! Filter on visual and unselect those values

[Anonymous]

There are thousands of records in each table, too many individual ones to filter.

[Anonymous]

also can use dax possibly

Month Select = CALCULATE(IF(ISCROSSFILTERED(Toronto_PCL_F20),1,0),ALLSELECTED(Toronto_PCL_F20)) something similar to cross filtered and all selected?