Forum Discussion
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...
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
Hi,
Maybe when I write the problem I was not clear what solution I was looking for.
I want to have a column saying TRUE or FALSE in the DESK SALE table, so I can be alerted visually.
The ones that are in yellow should have false.
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