Forum Discussion

Wael03's avatar
Wael03
Helper I
3 years ago
Solved

Filtering between two dataset

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

  • Wael03 , Plot this measure with ID of table A

     

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

1 Reply

  • Wael03 , Plot this measure with ID of table A

     

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