Categorise average percentages

Hi BassG 

Here is the sample data:

Then add a calculated table:

Table 2 = GENERATESERIES(0,100,10)

Finally, add a measure and create a Clustered Column Chart with it:

MEASURE =
VAR _currentValue =
    MAX ( 'Table 2'[Value] )
RETURN
    COUNTROWS (
        FILTER (
            SUMMARIZE (
                'Table',
                'Table'[Pupil ID],
                "_Avg", AVERAGE ( 'Table'[% Attendance Openings] )
            ),
            [_Avg] <= _currentValue
                && [_Avg] > _currentValue - 10
        )
    )

The result is as follow:

Best Regards

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