How to find valid values based on multiple tables

Thank you ryan_mayu .

This relies on manually define the variables, right?

So, if I have 30 different Data Validation table I'd need to define the variables one by one?

What I am trying to get is that the definition of the validation tables are in the raw data (which I have) and that this specifies where to go and find the valid values. I am trying something like the IF(...IN DISTINCT()) approach, but that moves away from having to hard-code (variables or many different, possibly hundreads of tables) in the DAX.  As I have already everything defined, either in the raw data or in the validation table, I would like to move away from the variables (unless they can be parametrised and created automatically from information in the raw data table).

Thank you