Counting number of ocurrences of one value of a table in another table

[qmestu]

Hi,

I've encountered this issue and have yet to find a way to fix it. I'll exemplify with 2 tables:

table A:

A	2020
B	2021
C	2020
D	2022

table B:

A	2020
A	2019
A	2018
B	2021
C	2020
C	2019

What i'm looking for is a way to count the number of ocorrences of A,B,C,D on the 2nd table where the year is not equal to the year registered in the 1st table. Both tables are connected through a many to many relationship.

This measure should yeld the following results:

A=2

B=0

C=1

D=0

Thank you in advance.

[ThxAlot · Accepted solution]