Validate the Data between two tables

[TomLU123]

Dear experts, 

I am currently building a report to validate the Location ID stored in a Participant Table. I wish to add a custom column "Location Validation Result" by comparing the location ID stored in Participant Table with Location Table. If it is a value stored in the Location Table, the result in that custom coumn will show Valid. If not found, the value will be Invalid. 

Participant Table:

Location Table:

Is it possible to use the express to do that?

Many thanks for your great help!

[Greg_Deckler]

Why us US2222 invalid?

[TomLU123]

Hi Greg! Sorry, that is a typo. US2222 is valid. 

[Greg_Deckler · Accepted solution]

If you have a relationship between your Location ID columns, then you could do this:

Column = IF(NOT(ISBLANK(CALCULATE(COUNTROWS('Locations')))),"Valid","Invalid")

Also, next time, please post text instead of screen shots of your data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[TomLU123]

Hi Greg, thank you so much for your help! I will post text next time. Thank you again for your help and advise!