filter a table excluding selected elements

[crodrigueza]

Hi, 

I would like to make a count on a table, but excluding first some elements in another table. The next example may clarify the situation:

Table A:

User	Product
A	Product A
B	Product B
C	Product B
D	Product B
E	Product A
F	Product C

Table B:

User	Email
A	A@outlook.com
B	B@outlook.com
C	C@outlook.com
D	D@outlook.com
E	E@outlook.com
F	F@outlook.com
G	G@outlook.com
H	H@outlook.com
I	I@outlook.com

Table A and Table B will have a relationship of 1:1 by user. Filtering table A by "Product A", I would like to count the users in table B different from those filtered in Table A:

Table B filtered:

User	Email
B	B@outlook.com
C	C@outlook.com
D	D@outlook.com
F	F@outlook.com
G	G@outlook.com
H	H@outlook.com
I	I@outlook.com

And the count result should be 7. Any ideas on how to achieve it?

Best regards, 

Carlos

[v-janeyg-msft · Accepted solution]

Hi, @crodrigueza 

Since you have created a one-to-one relationship in two tables.

You can directly create the measure like this:

Measure = var a= COUNTROWS(TableB)
var b=COUNTROWS(ALL(TableB))
return b-a

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey