Calculated Column in a slicer - Using between - Max value = max sum of number column

Hi Anonymous,

You can create a variable to calculate the average based on current week group, then you can use it as condition to filter records to get min and max summary values:

minValue =
VAR _avg =
    CALCULATE (
        AVERAGE ( 'Table'[duration] ),
        ALLSELECTED ( 'Table' ),
        VALUES ( 'Table'[weeknum] )
    )
RETURN
    SUMX ( FILTER ( ALLSELECTED ( 'Table' ), [duration] < _avg ), [duration] )

maxValue =
VAR _avg =
    CALCULATE (
        AVERAGE ( 'Table'[duration] ),
        ALLSELECTED ( 'Table' ),
        VALUES ( 'Table'[weeknum] )
    )
RETURN
    SUMX ( FILTER ( ALLSELECTED ( 'Table' ), [duration] > _avg ), [duration] )

Regards,

Xiaoxin Sheng