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. 

    Flag Matching Rows in Different.pbix32 KB
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. 

      Flag Matching Rows in Different.pbix32 KB
      • newpbiuser01's avatar
        newpbiuser01
        Helper V
        2 years ago

        Thank you Anonymous!