Filtering between two dataset

[Wael03]

Hi,

I have two datasets : Table A and Table B.

In those two datasets i have an ID column. The table A contains all the possible IDs, and the table B only the IDs that have been received by the company.

I would like to display in a table visualisation only the table A IDs that are not in the table B.

Do you know how can I do that ?

Thank you

[amitchandak · Accepted solution]

@Wael03 , Plot this measure with ID of table A

countrows(Except(distinct(TableA[ID]), distinct(TableB[ID]) ) )