Forum Discussion
Solved
Table Relationships & Cross-Filter Directions
I teach both elementary and high school-aged students. I have 3 tables. The first two are the individual grades for each student for each course I teach: ELEM SARAH MATH 95 BILLY ...
Hi CityCat35 ,
Based on my testing, please try the following methods again:
1.Create the new measure to show the letter grade based on the average results.
elem school Grade = VAR _Number = [Elem school average] RETURN CALCULATE(MAX('Third Table'[Letter]), _Number >= 'Third Table'[Min] && _Number <= 'Third Table'[Maz] && 'Third Table'[School] = "ELEM")High school letter = VAR _Number = [High school average] RETURN CALCULATE(MAX('Third Table'[Letter]), _Number >= 'Third Table'[Min] && _Number <= 'Third Table'[Maz] && 'Third Table'[School] = "HIGH SCHOOL")2.Drag the measure into the matrix visual.
3.The result is shown below.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi CityCat35 ,
Based on my testing, please try the following methods again:
1.Create the new measure to show the letter grade based on the average results.
elem school Grade =
VAR _Number = [Elem school average]
RETURN
CALCULATE(MAX('Third Table'[Letter]), _Number >= 'Third Table'[Min] && _Number <= 'Third Table'[Maz] && 'Third Table'[School] = "ELEM")High school letter =
VAR _Number = [High school average]
RETURN
CALCULATE(MAX('Third Table'[Letter]), _Number >= 'Third Table'[Min] && _Number <= 'Third Table'[Maz] && 'Third Table'[School] = "HIGH SCHOOL")2.Drag the measure into the matrix visual.
3.The result is shown below.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.