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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

You can have a new column in table1customer, that can help you to solve the problem

 

minx(FILTER('TABLE2PRODUCTS','TABLE1CUSTOMERS'[REGISTER_DATE]>'TABLE2PRODUCTS'[LAUNCH_DATE] 
&& 'TABLE1CUSTOMERS'[PRODUCTID ]='TABLE2PRODUCTS'[PRODUCTID ]),'TABLE2PRODUCTS'[LAUNCH_DATE])

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin