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