Count common values from another table

[Guenfood77]

Hi,

I've got 2 tables with same field "Id_User"

I'd like to count number of values in my Table2 which are in my Table1

With the example behind, the measure must display : 3 Id 1501, 2 Id 1502, 2 Id 1503 and 1 Id 1504

Thanks for your help.

Id_User Table 1	Id_User Table 2
1501	1501
1502	1501
1503	1501
1504	1502
	1502
	1503
	1503
	1504

[Anonymous · Accepted solution]

Create a relationship between the 2 tables in the model view.

Use the UserId column Table 1 is the one side, and Table2 is the many side.

Create a count measure in table2 - UserCount = COUNT( 'Table2'[UserId])

Please measure and UserId in a table visual or bar chart

[Guenfood77]

Thanks for your answer.

It seems ok but i've got a wrong result.

I forgot to apply a condition.

The count must integrate that value of field "Option" must be "1" in my Table1.

I tried to apply a filter in the formula but it doesn't match.