Forum Discussion

gauravnarchal's avatar
gauravnarchal
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

Measure to compare values in two different table

Hello, I need help to check if the numbers in table 1 are available in table 2 and find out the ones that do not exist in table 2. True / False.   I need this as measure and don't want to create a ...
Need Help
Show and Tell
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi,  gauravnarchal ;

    Try it.

    Result = IF(MAX('Table1'[Number]) in VALUES(Table2[Number]),"TRUE","FALSE")

    The final output is shown below:


    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
4 years ago

gauravnarchal Join the both table using relationship. Then create a measure in table 1:

Match = IF(SUM(Table1[Number]) IN {SUM(Table2[Number])}, TRUE(),FALSE())