Forum Discussion

wolfy_'s avatar
wolfy_
Helper I
8 years ago
Solved

Finding differences between tables

Hi,   I'm having some troubles to find if values between tables are correct.   I have two table, one for a sale is done online and other when the customer came to the shop and take the product th...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi wolfy_,

     

    Maybe you can try to use below measure formula:

     

    Tag =
VAR _currentID =
    SELECTEDVALUE ( 'Desk DB'[Sale ID] )
VAR list =
    CALCULATETABLE (
        VALUES ( 'Sale DB'[Customer Number] ),
        FILTER ( ALL ( 'Sale DB' ), 'Sale DB'[Sale ID] = _currentID )
    )
RETURN
    IF ( SELECTEDVALUE ( 'Desk DB'[Customer Number] ) IN list, TRUE (), FALSE () )

     

    If above not help,  can you please share us a pbix file for test? I will test and coding formula on it.

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI wolfy_,

 

I think you can try to use 'INTERSECT' function to get intersection records from two table, store them as variable table.

Then check current row content if it exist in variable table, return tag based on above result.

 

Reference link:

INTERSECT Function (DAX)

 

Regards,
Xiaoxin Sheng

  • wolfy_'s avatar
    wolfy_
    Helper I
    8 years ago

    HI,

     

    INTERSECT Function (DAX) seems a good solution, but my tables SALE DB and DESK SALE have more columms than just the [Sale ID] and [Customer number].