Forum Discussion
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 ...
Anonymous Should be able to do this:
Count Column = COUNTROWS(FILTER('Table 2'),'Table 2'[ID] = [ID]))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 Should be able to do this:
Count Column =
COUNTROWS(FILTER('Table 2'),'Table 2'[ID] = [ID]))
Greg_Deckler , you should correct the parantheses in your DAX-formula.