Count all shared values with condition

Hi everyone,   I cannot seem to figure out how to do the below. I have a table like this: User Entity A 1 A 2 A 3 B 2 C 1 C 2 C 4 D 2 D 4   Essentiall...