Search in a text column for values in another table Column using DAX and map the values

Hello, I've two tables Masterdata and Regions. Masterdata has a column called 'consolidated Region' and Region table has only one column 'Regions'. This table contains unique values of region. samp...