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 

     

     

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.