Calculate difference from the average

Hi mukhan 

to get the average, you could duplicate the initial query ( assume name table2), group by the individual ID and calculate the average (assume column name is avgcolumn) .

for the total, in the first query by creating a measure:

Measure =
var _totalscore =Calculate( sum('Table'[ColumnName]) , All (Table))

var _avgscore =selectedvalue('Table2'[AvgColumn])

var _output = _totalscore/_avgscore

return 

_output

plotting the measure on values with individual id/name, might give the result.

If it doesn't ,could you provide sample input data and sample output removing sensitive data ?

Appreciate a thumbs up if this is helpful.

Thanks