Forum Discussion

newpbiuser01's avatar
newpbiuser01
Helper V
3 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. 

newpbiuser01's avatar
newpbiuser01
Helper V
3 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!