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

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