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