Measure using filters on fields from related table

Hi dphillips 

Would these measures help?

Avg = 
    AVERAGEX(
        FILTER(
            ALL( 'Student' ),
            'Student'[Fileyear] = MAX( 'Student'[Fileyear] )
                && 'Student'[YearLevel] = MAX( 'Student'[YearLevel] )
        ),
        [TotalMeritsThisYear]
    )



MaxStudent = 
    MAXX(
        FILTER(
            ALL( 'Student' ),
            'Student'[Fileyear] = MAX( 'Student'[Fileyear] )
                && 'Student'[YearLevel] = MAX( 'Student'[YearLevel] )
        ),
        [TotalMeritsThisYear]
    )

On Page 2, you'll notice that [Avg] and [MaxStudent] change as [YearLevel] changes.  Also, you can compare the numbers to those on Page 1 where you can set slicers.

TestMerits-3.pbix

Hi,

PBI file attached.  I get 14 as the answer in the card visual.

Hope thish helps.