Forum Discussion

MarketingGerens's avatar
MarketingGerens
Frequent Visitor
6 years ago
Solved

FILTER TABLE BASED ON ANOTHER TABLE

Hi I have this 2 tables on my dashboard:   TABLE1CUSTOMERS CUSTOMERID   |  PRODUCTIDPURCHASE  |  REGISTER_DATE ________________________________________________________________ 101              ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hello,

    As you are trying to access the rows of a table on the one side of the relationship from the many side of the relationship, you need to use RELATED function.

    NEW_CUSTOMERS = COUNTX(FILTER(Cust,Cust[REGISTER_DATE]>RELATED(Products[LAUNCH_DATE])),Cust[CUSTOMERID]).

    Though using CALCULATE function too we could achieve the same result.

    This is yet another way of achieving it, without using calculate.

     

    Regards,

    Rakesh

Anonymous's avatar
Anonymous
Not applicable
6 years ago

MarketingGerens 

It seems your tables are related by product ID, you need to use RELATED() when referring to THE other table columns. 

 

NEW CUSTOMERS = CALCULATE(COUNT(Table1[ID]), FILTER('Table1','Table1'[Register Date]>RELATED(Table2[Launch Date])))

 


Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.