Forum Discussion

newpbiuser01's avatar
newpbiuser01
Helper V
2 years ago
Solved

Flag Matching Rows in Different Tables

Hello,   I am trying to flag rows with matching values in two different tables. As an example, I have two tables, Table1 with a list of items, and some reference data tied to the items. Table2 is a...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi newpbiuser01 ,

     

    You can create a measure.

    Result = IF(MAX('Table1'[Item]) in VALUES('Table2'[Item]), "Yes", BLANK())

     

    Best Regards,

    Neeko Tang

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

amitchandak's avatar
amitchandak
Super User
2 years ago

newpbiuser01 , You can add a new column in Table1

 

New col =

Var _cnt = countx(filter(Table2, Table1[Item] = Table2[Item]), Table2[Item])

return

if(isblank(_cnt), blank(), "Yes")

newpbiuser01's avatar
newpbiuser01
Helper V
2 years ago

Hi amitchandak,

 

Would you know if/how I could implement this as a measure? The reason I ask is, the goal is to make this "filterable" by the Shopper - which in my dataset is derived from the user() function. Unfortunately, I can't use that function in a calculated column. 

 

Thank you!

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi newpbiuser01 ,

     

    You can create a measure.

    Result = IF(MAX('Table1'[Item]) in VALUES('Table2'[Item]), "Yes", BLANK())

     

    Best Regards,

    Neeko Tang

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

    • newpbiuser01's avatar
      newpbiuser01
      Helper V
      2 years ago

      Thank you Anonymous!