Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to count a specific text value in a different table

Hi all!

 

I just started working with powerBI and can't find the right solution for my question.  I have the following tables/collumns

 

Table A 

- A collumn with names

 

Table B (customers)

- Collumn with names where customers bought something (Related to collumn in table A)

 

So in table A i want to add a collumn with the count of the names in collumn 1, and how many times they are mentioned in table B. I tried some count and if statements but haven't figured out the right statement. 

COUNT
DAX
if
  • az38's avatar
    az38
    6 years ago

    Hi Anonymous 

    it depends on full your data model, but in common case it could be enogh to create the next measure (if you have relationships between tables) to table1

    Measure = calculate(countrows('Table2'))

     

    do not hesitate to give a kudo to useful posts and mark solutions as solution

     

  • g_datasense's avatar
    g_datasense
    6 years ago

    Hello Anonymous ,

     

    You can create a calculate column on the Table A:

    CALCULATE(

             COUNT(Table B[name])
    )

     

    Or you can do the same with a measure. I think your column didn't work because you are not in the same context, for this you should use CALCULATE.

     

    Thanks,

    Guilherme

    https://www.linkedin.com/in/antunesguilherme 

     

     

3 Replies

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi Anonymous 

    it depends on full your data model, but in common case it could be enogh to create the next measure (if you have relationships between tables) to table1

    Measure = calculate(countrows('Table2'))

     

    do not hesitate to give a kudo to useful posts and mark solutions as solution

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Can i add a last date filter here as well? So that i can count only the values from the last date available.

  • g_datasense's avatar
    g_datasense
    Icon for Advocate I rankAdvocate I
    6 years ago

    Hello Anonymous ,

     

    You can create a calculate column on the Table A:

    CALCULATE(

             COUNT(Table B[name])
    )

     

    Or you can do the same with a measure. I think your column didn't work because you are not in the same context, for this you should use CALCULATE.

     

    Thanks,

    Guilherme

    https://www.linkedin.com/in/antunesguilherme