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, 2 Id 1503 and 1 Id 1504

Thanks for your help.

 

Id_User Table 1Id_User Table 2
15011501
15021501
15031501
15041502
 1502
 1503
 1503
 1504
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

2 Replies

  • 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.