How to count data in a table that cannot be found in another table

[Anonymous]

Hi guys,

I have 2 tables with UserID.  Table A contains all UserID while Table B contains UserIDs that are not active.

I will like to count USERIDs in TableA which are not included in TableB so as to know the number of active user.

Thanks a lot in advance!!!

Best regards

[Greg_Deckler]

COUNTROWS(EXCEPT(TableA, TableB))

[Anonymous]

Thanks a lot! It dint't work exactly but your idea gave me a way to search for the right context.

I found the answer through this: https://community.powerbi.com/t5/Desktop/How-to-count-rows-that-are-related-to-another-table/m-p/199...