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

Not sure if I understand your requirement correctly? Do you want to check if any customer exists in DESK SALE table but not in SALE DB?

 

If you are, try the following DAX.

 

Compare = CALCULATE(COUNTROWS('Sales-1'),FILTER('Sales-1','Sales-1'[Customer number]=EARLIER('Sales-2'[Customer number])))>0