Find values from one table based on calculated result from another table

CityCat35 

you can try this to get the grade

Column = maxx(FILTER(Table2,'Table'[Test Result]>=Table2[Min]&&'Table'[Test Result]<=Table2[Max]),Table2[Grade])

 

 

Hi CityCat35 

Create a measure

Average Score =
AVERAGE(Exams[Result])

Then to get the Grade

Average Grade =
IF([Average Score] >= 87, "A",
IF([Average Score] >= 75 && [Average Score] <= 86, "B",
IF([Average Score] >= 62 && [Average Score] <= 74, "C",
IF([Average Score] >=  44 && [Average Score] <= 61, "D",
IF([Average Score] <= 43, "F", BLANK()) 

Add the Student and Subject columns to a Table visual and then the measures

Hope this helps

Joe

Hi CityCat35 ,

Thanks Joe_Barry  and ryan_mayu  for the quick reply. Please allow me to provide additional insights:

(1)We can create measures.

Avg = AVERAGE('Table'[Test Result])

Grade = 
MAXX(FILTER(ALLSELECTED('Table (2)'),[Avg]>='Table (2)'[Min] && [Avg]<='Table (2)'[Max]),[Grade])

(2) Then the result is as follows.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.