Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

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

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Anonymous Should be able to do this:

     

    Count Column =
  COUNTROWS(FILTER('Table 2'),'Table 2'[ID] = [ID]))
  • nandukrishnavs's avatar
    nandukrishnavs
    6 years ago

    Anonymous 

     

    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     🙂 

6 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous Should be able to do this:

     

    Count Column =
  COUNTROWS(FILTER('Table 2'),'Table 2'[ID] = [ID]))
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      greg, thanks for helping.

       

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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

  • nandukrishnavs's avatar
    nandukrishnavs
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous 

     

    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     🙂 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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 !