Evaluation by Ranges of 2 different tables and that shows the value of a field, if it is true?

[Anonymous]

Good afternoon, greetings to the entire community, I am new to Power Bi and I am adapting, in this case I have 2 tables, of which
I have to evaluate certain values ​​in range, I explain myself better:

In the First Table "CAPI_LogRouteJournalTrans" I have 2 values:

a. ETHNICORIGINGID
b. EFICIENCIATRABAJADOR

that must be evaluated and compared with the "HCMETHNICORIGINCOMPLEMENT" table, the values ​​to be evaluated are 3:

a.ETHNICORIGINGID
b.FROMVALUE
C.TOVALUE
D. VALUECLASIFICATION

AT THE FIRST TABLE IT IS NECESSARY TO EVALUATE THE POINTS a AND b, COMPARE THEM WITH THE RANGES OF FROMVALUE AND TOVALUE AND ETHNICORIGINID THEN SHOW ME ACCORDING TO THE RANGE THE FIELD D. VALUECLASSIFICATION

Please I need guidance, what kind of formula should I use? in order to have the desired results, many thanks in advance

[Anonymous]

@amitchandak 

Thank you very much, I am attaching the result, honestly I am very impressed and surprised, I had been trying to do this for many days.
I did the power bi course but they didn't explain DAX to us in depth, could you please recommend a DAX course or some material that I can consult? Thank you again...

[amitchandak · Accepted solution]

@Anonymous , You can have new column in table A

maxx(filter(Table2, table1[ETHNICORIGINGID]  = Table2[ETHNICORIGINGID] && table1[EFICIENCIATRABAJADOR]  >= Table2[FROMVALUE]  && table1[EFICIENCIATRABAJADOR]  <= Table2[TOVALUE]  ), Table1[VALUECLASIFICATION])