Distributed Averages

Hi cottrera ,

You can refer to below table expression.

Score = 
VAR TempTable = ADDCOLUMNS(ALL('Table'[Unit Reference]),"Repairs",CALCULATE(COUNTROWS('Table')))
VAR AverageRepairs = ROUND(AVERAGEX(TempTable,[Repairs]),0)
VAR ScoreTable = 
    SELECTCOLUMNS(
        {
            ("Greater then twice above average",5,AverageRepairs*2+1,99999),
            ("Between above average and twice above average",4,AverageRepairs+1,AverageRepairs*2),
            ("Average",3,AverageRepairs,AverageRepairs),
            ("Between 5 and average",2,6,AverageRepairs-1),
            ("Between zero and 5",1,1,5),
            ("Zero",1,0,0)
        },
        "Score Name",[Value1],
        "Score",[Value2],
        "Min",[Value3],
        "Max",[Value4]
    )
RETURN
ADDCOLUMNS(
    TempTable,
    "Score Name",
        MAXX(FILTER(ScoreTable,[Min]<=[Repairs] && [Repairs]<=[Max]),[Score Name]),
    "Score",
        MAXX(FILTER(ScoreTable,[Min]<=[Repairs] && [Repairs]<=[Max]),[Score])
)

Demo - Distributed Averages.pbix

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~