Count (calculated table) from another table - No relationship!

[ferbyrez]

Hi guys,

I´ve been trying to solve this but without sucess. basically I need a matrix ( or a table ) as described below:
I tryed the Calculate(count(filter))) but it shows me the same value per line.. 

i´m importing the columns to a table and want this calculation..

thanks !!

[Greg_Deckler · Accepted solution]

@ferbyrez Should be able to do this:

Count Column =
  COUNTROWS(FILTER('Table 2'),'Table 2'[ID] = [ID]))

[nandukrishnavs · Accepted solution]

@ferbyrez 

Try below the DAX measure.

Count from Table 2, Yes = 
VAR __selectedID =
    SELECTEDVALUE ( Table1[Id] )
VAR __count =
    COUNTX (
        FILTER ( Table2, Table2[Id] = __selectedID && Table2[Filter Table 2] = "Yes" ),
        Table2[Id]
    )
RETURN
    IF(ISBLANK(__count),0,__count)

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂 

[ferbyrez]

It works bro! thanks all you guys.

Another solution : I created a colum based on the Filter2 Yes (if. .. filter = YES , "YES")

Created a new Table only with this columns.

Used the first formula @Greg_Deckler posted.

Thanks !

[Greg_Deckler · Accepted solution]

@ferbyrez Should be able to do this:

Count Column =
  COUNTROWS(FILTER('Table 2'),'Table 2'[ID] = [ID]))

[Power_BI_Mike]

@Greg_Deckler , you should correct the parantheses in your DAX-formula.

[ferbyrez]

@Greg_Deckler  it works perfectly to the purpose of "how many time appears in the other column" !

Now I need to "how many time appears in the other column with some specif filters in another column".

Thanks. bro

[ferbyrez]

greg, thanks for helping.

but this cause will not bring me the filters I need in table 2 (YES), won´t it ?