topic Re: How to count a specific text value in a different table in DAX Commands and Tips

How to count a specific text value in a different table

Anonymous — Wed, 22 Jan 2020 09:20:53 GMT

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.

Re: How to count a specific text value in a different table

az38 — Wed, 22 Jan 2020 10:06:18 GMT

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

Re: How to count a specific text value in a different table

g_datasense — Wed, 22 Jan 2020 10:17:43 GMT

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

Re: How to count a specific text value in a different table

Anonymous — Fri, 24 Jan 2020 12:54:16 GMT

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