Forum Discussion
Solved
Count common values from another table
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, ...
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
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