Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Reference column in second table using filtered column

Hi all,  I am trying to replicate the above.  I have 2 tables which can be described as -  Table 1: Product name and share columns, there is also retailer & state columns (not shown above)...
DAX
Filter
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Try new measures like

 

comp1 = maxx(filter(Table2, Table2[Comp1] = max(Table1[Name])),Table2[Comp1])


comp1 Share = maxx(filter(allselected(Table1), Table1[Comp1] = [comp1],Table1[Share])

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks for your reply. 

     

    The first formula (comp1) did not return a value (BLANK).