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

     

     

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