Issue with Top N

Hi Anonymous ,

I suggest you to create a measure for average value.

Firstly update [OR Filter] measure.

OR Filter = 
IF (
    OR (
        SELECTEDVALUE ( 'Table H'[Id] ) IN ALLSELECTED ( Acc[Id] ),
        // Checks if current Account is in slicer selection
        SELECTEDVALUE ( 'Table H'[Id] ) IN ALLSELECTED ( 'Non Acc'[Id] )
        // Checks if current Non Account is in slicer selection
    ),
    1, // Return 1 if value is selected in one or both of the slicers
    0  // Else return 0
)

Measure:

Measure = 
VAR _Summairze =
    SUMMARIZE (
        FILTER ( 'Table S', [OR Filter] = 1 ),
        'Table S'[clild Id],
        "ID", CALCULATE ( MAX ( 'Table H'[Id] ) ),
        "Average of Value", CALCULATE ( AVERAGE ( 'Table D'[Value] ) )
    )
RETURN
    SUMX ( _Summairze, [Average of Value] )

Add it into TopN filter in Child ID column. Result is as below.

Best Regards,
Rico Zhou

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