Forum Discussion

Guenfood77's avatar
Guenfood77
Frequent Visitor
2 years ago
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, ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    Guenfood77
    Frequent Visitor
    2 years ago

    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.